APPS.OKC_XPRT_QA_PVT dependencies on FND_LOG

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

6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_QA_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

176:
177: BEGIN
178:
179: -- start debug log
180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
182: G_MODULE||l_api_name,
183: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
184: END IF;

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

177: BEGIN
178:
179: -- start debug log
180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
182: G_MODULE||l_api_name,
183: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
184: END IF;
185:

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

240: p_qa_errors_t_rec.RULE_ID
241: );
242:
243: -- end debug log
244: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
245: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
246: G_MODULE||l_api_name,
247: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
248: END IF;

Line 245: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

241: );
242:
243: -- end debug log
244: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
245: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
246: G_MODULE||l_api_name,
247: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
248: END IF;
249:

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

248: END IF;
249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
254: G_MODULE||l_api_name,
255: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
256: END IF;

Line 253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
253: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
254: G_MODULE||l_api_name,
255: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
256: END IF;
257:

Line 348: IF (Fnd_Log.Level_Procedure >= Fnd_Log.g_Current_Runtime_Level) THEN

344:
345: BEGIN
346:
347: -- start debug log
348: IF (Fnd_Log.Level_Procedure >= Fnd_Log.g_Current_Runtime_Level) THEN
349: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
350: g_Module || l_Api_Name,
351: '100: Entered ' || g_Pkg_Name || '.' || l_Api_Name);
352: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 349: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

345: BEGIN
346:
347: -- start debug log
348: IF (Fnd_Log.Level_Procedure >= Fnd_Log.g_Current_Runtime_Level) THEN
349: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
350: g_Module || l_Api_Name,
351: '100: Entered ' || g_Pkg_Name || '.' || l_Api_Name);
352: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
353: g_Module || l_Api_Name,

Line 352: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

348: IF (Fnd_Log.Level_Procedure >= Fnd_Log.g_Current_Runtime_Level) THEN
349: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
350: g_Module || l_Api_Name,
351: '100: Entered ' || g_Pkg_Name || '.' || l_Api_Name);
352: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
353: g_Module || l_Api_Name,
354: '100: Parameters passed: -----------------------');
355: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
356: g_Module || l_Api_Name,

Line 355: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

351: '100: Entered ' || g_Pkg_Name || '.' || l_Api_Name);
352: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
353: g_Module || l_Api_Name,
354: '100: Parameters passed: -----------------------');
355: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
356: g_Module || l_Api_Name,
357: '200: p_rule_Id:' || p_rule_id);
358: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
359: g_Module || l_Api_Name,

Line 358: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

354: '100: Parameters passed: -----------------------');
355: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
356: g_Module || l_Api_Name,
357: '200: p_rule_Id:' || p_rule_id);
358: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
359: g_Module || l_Api_Name,
360: '200: p_sequence_Id:' || p_sequence_id);
361: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
362: g_Module || l_Api_Name,

Line 361: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

357: '200: p_rule_Id:' || p_rule_id);
358: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
359: g_Module || l_Api_Name,
360: '200: p_sequence_Id:' || p_sequence_id);
361: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
362: g_Module || l_Api_Name,
363: '100: Parameters passed: -----------------------');
364: END IF;
365:

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

383: l_Template_Id := Template_Rec.Template_Id;
384: l_Org_Id := Template_Rec.Org_Id;
385: l_Intent := Template_Rec.Intent;
386:
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
389: g_Module || l_Api_Name,
390: '200: Checking for l_Template_Id:' || l_Template_Id);
391: END IF;

Line 388: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

384: l_Org_Id := Template_Rec.Org_Id;
385: l_Intent := Template_Rec.Intent;
386:
387: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
389: g_Module || l_Api_Name,
390: '200: Checking for l_Template_Id:' || l_Template_Id);
391: END IF;
392:

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

466: ' and rules.rule_id in ' ||l_request_rule_ids||
467:
468: ' )';
469:
470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
472: g_Module || l_Api_Name,
473: '205a: Stored the SQL on l_sql_string');
474: END IF;

Line 471: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

467:
468: ' )';
469:
470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
472: g_Module || l_Api_Name,
473: '205a: Stored the SQL on l_sql_string');
474: END IF;
475:

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

474: END IF;
475:
476: OPEN insert_cursor FOR l_sql_string;
477:
478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
480: g_Module || l_Api_Name,
481: '205b: l_sql_string :' || l_sql_string);
482: END IF;

Line 479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

475:
476: OPEN insert_cursor FOR l_sql_string;
477:
478: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
479: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
480: g_Module || l_Api_Name,
481: '205b: l_sql_string :' || l_sql_string);
482: END IF;
483:

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

485: LOOP
486:
487: FETCH insert_cursor INTO condition_question_id, outcome_question_id;
488:
489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
491: g_Module || l_Api_Name,
492: '210: condition_question_id:' || condition_question_id);
493: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

Line 490: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

486:
487: FETCH insert_cursor INTO condition_question_id, outcome_question_id;
488:
489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
491: g_Module || l_Api_Name,
492: '210: condition_question_id:' || condition_question_id);
493: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
494: g_Module || l_Api_Name,

Line 493: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
491: g_Module || l_Api_Name,
492: '210: condition_question_id:' || condition_question_id);
493: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
494: g_Module || l_Api_Name,
495: '220: outcome_question_id:' || outcome_question_id);
496: END IF;
497:

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

521: exception
522:
523: WHEN Circular_Ref_Exception THEN
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
527: g_Module || l_Api_Name,
528: '300: Failed for l_Template_Id:' || l_Template_Id);
529: END IF;

Line 526: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

522:
523: WHEN Circular_Ref_Exception THEN
524:
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
527: g_Module || l_Api_Name,
528: '300: Failed for l_Template_Id:' || l_Template_Id);
529: END IF;
530:

Line 578: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.g_Current_Runtime_Level) THEN

574:
575: -- handle the QA error
576: WHEN OTHERS THEN
577:
578: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.g_Current_Runtime_Level) THEN
579: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
580: g_Module || l_Api_Name,
581: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
582: END IF;

Line 579: Fnd_Log.STRING(Fnd_Log.Level_Procedure,

575: -- handle the QA error
576: WHEN OTHERS THEN
577:
578: IF (Fnd_Log.LEVEL_PROCEDURE >= Fnd_Log.g_Current_Runtime_Level) THEN
579: Fnd_Log.STRING(Fnd_Log.Level_Procedure,
580: g_Module || l_Api_Name,
581: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
582: END IF;
583:

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

670:
671: BEGIN
672:
673: -- start debug log
674: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
676: G_MODULE||l_api_name,
677: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
678: END IF;

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

671: BEGIN
672:
673: -- start debug log
674: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
676: G_MODULE||l_api_name,
677: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
678: END IF;
679:

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

772:
773: END LOOP; -- all clauses in rule
774:
775: -- end debug log
776: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
778: G_MODULE||l_api_name,
779: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
780: END IF;

Line 777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

773: END LOOP; -- all clauses in rule
774:
775: -- end debug log
776: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
778: G_MODULE||l_api_name,
779: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
780: END IF;
781:

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

780: END IF;
781:
782: EXCEPTION
783: WHEN FND_API.G_EXC_ERROR THEN
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,
787: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
788: END IF;

Line 785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

781:
782: EXCEPTION
783: WHEN FND_API.G_EXC_ERROR THEN
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,
787: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
788: END IF;
789:

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

790: x_return_status := G_RET_STS_ERROR ;
791: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
796: G_MODULE||l_api_name,
797: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
798: END IF;

Line 795: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

791: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
796: G_MODULE||l_api_name,
797: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
798: END IF;
799:

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

800: x_return_status := G_RET_STS_UNEXP_ERROR ;
801: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
802:
803: WHEN OTHERS THEN
804: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,
807: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
808: END IF;

Line 805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

801: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
802:
803: WHEN OTHERS THEN
804: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,
807: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
808: END IF;
809:

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

893:
894: BEGIN
895:
896: -- start debug log
897: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
899: G_MODULE||l_api_name,
900: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
901: END IF;

Line 898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

894: BEGIN
895:
896: -- start debug log
897: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
898: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
899: G_MODULE||l_api_name,
900: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
901: END IF;
902:

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

953:
954: END LOOP; -- all clauses in rule
955:
956: -- end debug log
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
959: G_MODULE||l_api_name,
960: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
961: END IF;

Line 958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

954: END LOOP; -- all clauses in rule
955:
956: -- end debug log
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
959: G_MODULE||l_api_name,
960: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
961: END IF;
962:

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

961: END IF;
962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
967: G_MODULE||l_api_name,
968: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
969: END IF;

Line 966: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

962:
963: EXCEPTION
964: WHEN FND_API.G_EXC_ERROR THEN
965: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
967: G_MODULE||l_api_name,
968: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
969: END IF;
970:

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

971: x_return_status := G_RET_STS_ERROR ;
972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
977: G_MODULE||l_api_name,
978: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
979: END IF;

Line 976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
977: G_MODULE||l_api_name,
978: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
979: END IF;
980:

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

981: x_return_status := G_RET_STS_UNEXP_ERROR ;
982: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
983:
984: WHEN OTHERS THEN
985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
987: G_MODULE||l_api_name,
988: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
989: END IF;

Line 986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

982: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
983:
984: WHEN OTHERS THEN
985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
987: G_MODULE||l_api_name,
988: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
989: END IF;
990:

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

1107:
1108: BEGIN
1109:
1110: -- start debug log
1111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1113: G_MODULE||l_api_name,
1114: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1115: END IF;

Line 1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1108: BEGIN
1109:
1110: -- start debug log
1111: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1112: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1113: G_MODULE||l_api_name,
1114: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1115: END IF;
1116:

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

1178: l_sql_stmt := 'SELECT '||l_name_col||' , '||l_id_col||
1179: ' FROM '||l_table_name||' '||
1180: l_additional_where_clause ;
1181:
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1184: G_MODULE||l_api_name,
1185: '150: l_table_name '||l_table_name);
1186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1179: ' FROM '||l_table_name||' '||
1180: l_additional_where_clause ;
1181:
1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1184: G_MODULE||l_api_name,
1185: '150: l_table_name '||l_table_name);
1186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1187: G_MODULE||l_api_name,

Line 1186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1182: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1184: G_MODULE||l_api_name,
1185: '150: l_table_name '||l_table_name);
1186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1187: G_MODULE||l_api_name,
1188: '150: l_name_col '||l_name_col);
1189: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1190: G_MODULE||l_api_name,

Line 1189: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1185: '150: l_table_name '||l_table_name);
1186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1187: G_MODULE||l_api_name,
1188: '150: l_name_col '||l_name_col);
1189: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1190: G_MODULE||l_api_name,
1191: '150: l_id_col '||l_id_col);
1192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1193: G_MODULE||l_api_name,

Line 1192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1188: '150: l_name_col '||l_name_col);
1189: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1190: G_MODULE||l_api_name,
1191: '150: l_id_col '||l_id_col);
1192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1193: G_MODULE||l_api_name,
1194: '150: l_additional_where_clause '||l_additional_where_clause);
1195: END IF;
1196: -- execute the dynamic sql

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

1369:
1370: END LOOP; -- all questions in rule
1371:
1372: -- end debug log
1373: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1375: G_MODULE||l_api_name,
1376: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1377: END IF;

Line 1374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1370: END LOOP; -- all questions in rule
1371:
1372: -- end debug log
1373: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1375: G_MODULE||l_api_name,
1376: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1377: END IF;
1378:

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

1377: END IF;
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1383: G_MODULE||l_api_name,
1384: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1385: END IF;

Line 1382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1383: G_MODULE||l_api_name,
1384: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1385: END IF;
1386:

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

1387: x_return_status := G_RET_STS_ERROR ;
1388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1392: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1393: G_MODULE||l_api_name,
1394: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1395: END IF;

Line 1392: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1392: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1393: G_MODULE||l_api_name,
1394: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1395: END IF;
1396:

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

1397: x_return_status := G_RET_STS_UNEXP_ERROR ;
1398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1399:
1400: WHEN OTHERS THEN
1401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1403: G_MODULE||l_api_name,
1404: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1405: END IF;

Line 1402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1399:
1400: WHEN OTHERS THEN
1401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1403: G_MODULE||l_api_name,
1404: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1405: END IF;
1406:

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

1523:
1524: BEGIN
1525:
1526: -- start debug log
1527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1529: G_MODULE||l_api_name,
1530: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1531: END IF;

Line 1528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1524: BEGIN
1525:
1526: -- start debug log
1527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1529: G_MODULE||l_api_name,
1530: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1531: END IF;
1532:

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

1653: l_sql_stmt := 'SELECT '||l_name_col||' , '||l_id_col||
1654: ' FROM '||l_table_name||' '||
1655: l_additional_where_clause ;
1656:
1657: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1659: G_MODULE||l_api_name,
1660: '150: l_table_name '||l_table_name);
1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1654: ' FROM '||l_table_name||' '||
1655: l_additional_where_clause ;
1656:
1657: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1659: G_MODULE||l_api_name,
1660: '150: l_table_name '||l_table_name);
1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1662: G_MODULE||l_api_name,

Line 1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1657: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1658: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1659: G_MODULE||l_api_name,
1660: '150: l_table_name '||l_table_name);
1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1662: G_MODULE||l_api_name,
1663: '150: l_name_col '||l_name_col);
1664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1665: G_MODULE||l_api_name,

Line 1664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1660: '150: l_table_name '||l_table_name);
1661: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1662: G_MODULE||l_api_name,
1663: '150: l_name_col '||l_name_col);
1664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1665: G_MODULE||l_api_name,
1666: '150: l_id_col '||l_id_col);
1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1668: G_MODULE||l_api_name,

Line 1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1663: '150: l_name_col '||l_name_col);
1664: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1665: G_MODULE||l_api_name,
1666: '150: l_id_col '||l_id_col);
1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1668: G_MODULE||l_api_name,
1669: '150: l_additional_where_clause '||l_additional_where_clause);
1670: END IF;
1671:

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

1853:
1854: END LOOP; -- all variables in rule
1855:
1856: -- end debug log
1857: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1859: G_MODULE||l_api_name,
1860: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1861: END IF;

Line 1858: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1854: END LOOP; -- all variables in rule
1855:
1856: -- end debug log
1857: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1858: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1859: G_MODULE||l_api_name,
1860: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1861: END IF;
1862:

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

1861: END IF;
1862:
1863: EXCEPTION
1864: WHEN FND_API.G_EXC_ERROR THEN
1865: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1867: G_MODULE||l_api_name,
1868: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1869: END IF;

Line 1866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1862:
1863: EXCEPTION
1864: WHEN FND_API.G_EXC_ERROR THEN
1865: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1866: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1867: G_MODULE||l_api_name,
1868: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1869: END IF;
1870:

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

1871: x_return_status := G_RET_STS_ERROR ;
1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1877: G_MODULE||l_api_name,
1878: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1879: END IF;

Line 1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1877: G_MODULE||l_api_name,
1878: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1879: END IF;
1880:

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

1881: x_return_status := G_RET_STS_UNEXP_ERROR ;
1882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1883:
1884: WHEN OTHERS THEN
1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1887: G_MODULE||l_api_name,
1888: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1889: END IF;

Line 1886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1883:
1884: WHEN OTHERS THEN
1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1887: G_MODULE||l_api_name,
1888: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1889: END IF;
1890:

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

1952:
1953: BEGIN
1954:
1955: -- start debug log
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1958: G_MODULE||l_api_name,
1959: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1960: END IF;

Line 1957: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1953: BEGIN
1954:
1955: -- start debug log
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1958: G_MODULE||l_api_name,
1959: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1960: END IF;
1961:

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

2003: x_qa_status := 'E';
2004: END LOOP; -- all questions that were disabled
2005:
2006: -- end debug log
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: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2011: END IF;

Line 2008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2004: END LOOP; -- all questions that were disabled
2005:
2006: -- end debug log
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: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2011: END IF;
2012:

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

2011: END IF;
2012:
2013: EXCEPTION
2014: WHEN FND_API.G_EXC_ERROR THEN
2015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2017: G_MODULE||l_api_name,
2018: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2019: END IF;

Line 2016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2012:
2013: EXCEPTION
2014: WHEN FND_API.G_EXC_ERROR THEN
2015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2017: G_MODULE||l_api_name,
2018: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2019: END IF;
2020:

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

2021: x_return_status := G_RET_STS_ERROR ;
2022: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2026: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2027: G_MODULE||l_api_name,
2028: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2029: END IF;

Line 2026: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2022: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2026: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2027: G_MODULE||l_api_name,
2028: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2029: END IF;
2030:

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

2031: x_return_status := G_RET_STS_UNEXP_ERROR ;
2032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2033:
2034: WHEN OTHERS THEN
2035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,
2038: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2039: END IF;

Line 2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2033:
2034: WHEN OTHERS THEN
2035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,
2038: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2039: END IF;
2040:

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

2081:
2082: BEGIN
2083:
2084: -- start debug log
2085: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2087: G_MODULE||l_api_name,
2088: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2089: END IF;

Line 2086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2082: BEGIN
2083:
2084: -- start debug log
2085: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2087: G_MODULE||l_api_name,
2088: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2089: END IF;
2090:

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

2141:
2142:
2143:
2144: -- end debug log
2145: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2147: G_MODULE||l_api_name,
2148: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2149: END IF;

Line 2146: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2142:
2143:
2144: -- end debug log
2145: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2147: G_MODULE||l_api_name,
2148: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2149: END IF;
2150:

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

2149: END IF;
2150:
2151: EXCEPTION
2152: WHEN FND_API.G_EXC_ERROR THEN
2153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2155: G_MODULE||l_api_name,
2156: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2157: END IF;

Line 2154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2150:
2151: EXCEPTION
2152: WHEN FND_API.G_EXC_ERROR THEN
2153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2155: G_MODULE||l_api_name,
2156: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2157: END IF;
2158:

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

2159: x_return_status := G_RET_STS_ERROR ;
2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2165: G_MODULE||l_api_name,
2166: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2167: END IF;

Line 2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2165: G_MODULE||l_api_name,
2166: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2167: END IF;
2168:

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

2169: x_return_status := G_RET_STS_UNEXP_ERROR ;
2170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2171:
2172: WHEN OTHERS THEN
2173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2175: G_MODULE||l_api_name,
2176: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2177: END IF;

Line 2174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2171:
2172: WHEN OTHERS THEN
2173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2175: G_MODULE||l_api_name,
2176: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2177: END IF;
2178:

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

2278:
2279: BEGIN
2280:
2281: -- start debug log
2282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2284: G_MODULE||l_api_name,
2285: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2286: END IF;

Line 2283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2279: BEGIN
2280:
2281: -- start debug log
2282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2283: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2284: G_MODULE||l_api_name,
2285: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2286: END IF;
2287:

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

2301: OPEN csr_check_proc_exists(p_procedure_name => rec_rule_variables_w_proc.procedure_name);
2302: FETCH csr_check_proc_exists INTO l_dummy;
2303:
2304: -- Debug log
2305: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2307: G_MODULE||l_api_name,
2308: '120: Checking Procedure spec/body ' || rec_rule_variables_w_proc.procedure_name ||
2309: 'validity for variable'||rec_rule_variables_w_proc.variable_name);

Line 2306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2302: FETCH csr_check_proc_exists INTO l_dummy;
2303:
2304: -- Debug log
2305: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2307: G_MODULE||l_api_name,
2308: '120: Checking Procedure spec/body ' || rec_rule_variables_w_proc.procedure_name ||
2309: 'validity for variable'||rec_rule_variables_w_proc.variable_name);
2310: END IF;

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

2351: RETURN;
2352: END IF; -- Procedure Spec is invalid
2353:
2354: -- Debug log
2355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2357: G_MODULE||l_api_name,
2358: '110: Checking Procedure spec/body ' || rec_rule_variables_w_proc.procedure_name ||
2359: 'existence for variable'||rec_rule_variables_w_proc.variable_name);

Line 2356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2352: END IF; -- Procedure Spec is invalid
2353:
2354: -- Debug log
2355: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2356: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2357: G_MODULE||l_api_name,
2358: '110: Checking Procedure spec/body ' || rec_rule_variables_w_proc.procedure_name ||
2359: 'existence for variable'||rec_rule_variables_w_proc.variable_name);
2360: END IF;

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

2407:
2408: END LOOP; -- all Vairables with procedures in rule
2409:
2410: -- end debug log
2411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2413: G_MODULE||l_api_name,
2414: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2415: END IF;

Line 2412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2408: END LOOP; -- all Vairables with procedures in rule
2409:
2410: -- end debug log
2411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2413: G_MODULE||l_api_name,
2414: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2415: END IF;
2416:

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

2415: END IF;
2416:
2417: EXCEPTION
2418: WHEN FND_API.G_EXC_ERROR THEN
2419: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2421: G_MODULE||l_api_name,
2422: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2423: END IF;

Line 2420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2416:
2417: EXCEPTION
2418: WHEN FND_API.G_EXC_ERROR THEN
2419: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2420: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2421: G_MODULE||l_api_name,
2422: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2423: END IF;
2424:

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

2425: x_return_status := G_RET_STS_ERROR ;
2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2427:
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2431: G_MODULE||l_api_name,
2432: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2433: END IF;

Line 2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2427:
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2431: G_MODULE||l_api_name,
2432: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2433: END IF;
2434:

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

2435: x_return_status := G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437:
2438: WHEN OTHERS THEN
2439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2441: G_MODULE||l_api_name,
2442: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2443: END IF;

Line 2440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437:
2438: WHEN OTHERS THEN
2439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2441: G_MODULE||l_api_name,
2442: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2443: END IF;
2444:

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

2491:
2492: BEGIN
2493:
2494: -- start debug log
2495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2497: G_MODULE||l_api_name,
2498: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2492: BEGIN
2493:
2494: -- start debug log
2495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2497: G_MODULE||l_api_name,
2498: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2500: G_MODULE||l_api_name,

Line 2499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2495: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2497: G_MODULE||l_api_name,
2498: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2499: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2500: G_MODULE||l_api_name,
2501: 'Parameter : '||p_qa_mode);
2502: END IF;
2503:

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

2511:
2512: x_sequence_id := l_sequence_id;
2513:
2514: -- debug
2515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2517: G_MODULE||l_api_name,
2518: '110: Sequence Id : '||l_sequence_id);
2519: END IF;

Line 2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2512: x_sequence_id := l_sequence_id;
2513:
2514: -- debug
2515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2517: G_MODULE||l_api_name,
2518: '110: Sequence Id : '||l_sequence_id);
2519: END IF;
2520:

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

2561: l_rule_qa_status := 'E';
2562: END IF;
2563:
2564: -- debug
2565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2567: G_MODULE||l_api_name,
2568: '120: After Calling check_expired_clauses x_qa_status : '||x_qa_status);
2569: END IF;

Line 2566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2562: END IF;
2563:
2564: -- debug
2565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2567: G_MODULE||l_api_name,
2568: '120: After Calling check_expired_clauses x_qa_status : '||x_qa_status);
2569: END IF;
2570:

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

2591: l_rule_qa_status := 'E';
2592: END IF;
2593:
2594: -- debug
2595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2597: G_MODULE||l_api_name,
2598: '120: After Calling check_draft_clauses x_qa_status : '||x_qa_status);
2599: END IF;

Line 2596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2592: END IF;
2593:
2594: -- debug
2595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2597: G_MODULE||l_api_name,
2598: '120: After Calling check_draft_clauses x_qa_status : '||x_qa_status);
2599: END IF;
2600:

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

2622: l_rule_qa_status := 'E';
2623: END IF;
2624:
2625: -- debug
2626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2628: G_MODULE||l_api_name,
2629: '120: After Calling check_circular_dependency x_qa_status : '||x_qa_status);
2630: END IF;

Line 2627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2623: END IF;
2624:
2625: -- debug
2626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2628: G_MODULE||l_api_name,
2629: '120: After Calling check_circular_dependency x_qa_status : '||x_qa_status);
2630: END IF;
2631:

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

2652: l_rule_qa_status := 'E';
2653: END IF;
2654:
2655: -- debug
2656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2658: G_MODULE||l_api_name,
2659: '120: After Calling check_invalid_questions x_qa_status : '||x_qa_status);
2660: END IF;

Line 2657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2653: END IF;
2654:
2655: -- debug
2656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2658: G_MODULE||l_api_name,
2659: '120: After Calling check_invalid_questions x_qa_status : '||x_qa_status);
2660: END IF;
2661:

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

2681: l_rule_qa_status := 'E';
2682: END IF;
2683:
2684: -- debug
2685: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2687: G_MODULE||l_api_name,
2688: '120: After Calling check_rule_templates x_qa_status : '||x_qa_status);
2689: END IF;

Line 2686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2682: END IF;
2683:
2684: -- debug
2685: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2686: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2687: G_MODULE||l_api_name,
2688: '120: After Calling check_rule_templates x_qa_status : '||x_qa_status);
2689: END IF;
2690:

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

2710: l_rule_qa_status := 'E';
2711: END IF;
2712:
2713: -- debug
2714: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2716: G_MODULE||l_api_name,
2717: '120: After Calling check_invalid_vset_var x_qa_status : '||x_qa_status);
2718: END IF;

Line 2715: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2711: END IF;
2712:
2713: -- debug
2714: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2715: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2716: G_MODULE||l_api_name,
2717: '120: After Calling check_invalid_vset_var x_qa_status : '||x_qa_status);
2718: END IF;
2719:

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

2748: l_rule_qa_status := 'E';
2749: END IF;
2750:
2751: -- debug
2752: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2754: G_MODULE||l_api_name,
2755: '120: After Calling check_invalid_vset_qst x_qa_status : '||x_qa_status);
2756: END IF;

Line 2753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2749: END IF;
2750:
2751: -- debug
2752: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2753: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2754: G_MODULE||l_api_name,
2755: '120: After Calling check_invalid_vset_qst x_qa_status : '||x_qa_status);
2756: END IF;
2757:

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

2778: l_rule_qa_status := 'E';
2779: END IF;
2780:
2781: -- debug
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: '125: After Calling check_invalid_udv_procedure x_qa_status : '||x_qa_status);
2786: END IF;

Line 2783: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2779: END IF;
2780:
2781: -- debug
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: '125: After Calling check_invalid_udv_procedure x_qa_status : '||x_qa_status);
2786: END IF;
2787:

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

2826:
2827:
2828:
2829: -- end debug log
2830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2832: G_MODULE||l_api_name,
2833: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2834: END IF;

Line 2831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2827:
2828:
2829: -- end debug log
2830: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2831: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2832: G_MODULE||l_api_name,
2833: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2834: END IF;
2835:

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

2834: END IF;
2835:
2836: EXCEPTION
2837: WHEN FND_API.G_EXC_ERROR THEN
2838: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2840: G_MODULE||l_api_name,
2841: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2842: END IF;

Line 2839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2835:
2836: EXCEPTION
2837: WHEN FND_API.G_EXC_ERROR THEN
2838: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2839: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2840: G_MODULE||l_api_name,
2841: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2842: END IF;
2843:

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

2844: x_return_status := G_RET_STS_ERROR ;
2845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2846:
2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2850: G_MODULE||l_api_name,
2851: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2852: END IF;

Line 2849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2846:
2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2850: G_MODULE||l_api_name,
2851: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2852: END IF;
2853:

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

2854: x_return_status := G_RET_STS_UNEXP_ERROR ;
2855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2856:
2857: WHEN OTHERS THEN
2858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2860: G_MODULE||l_api_name,
2861: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2862: END IF;

Line 2859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2856:
2857: WHEN OTHERS THEN
2858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2860: G_MODULE||l_api_name,
2861: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2862: END IF;
2863:

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

2903:
2904: BEGIN
2905:
2906: -- start debug log
2907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2908: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2909: G_MODULE||l_api_name,
2910: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2908: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2904: BEGIN
2905:
2906: -- start debug log
2907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2908: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2909: G_MODULE||l_api_name,
2910: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2912: G_MODULE||l_api_name,

Line 2911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2908: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2909: G_MODULE||l_api_name,
2910: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2912: G_MODULE||l_api_name,
2913: 'Parameter p_sync_mode : '||p_sync_mode);
2914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2915: G_MODULE||l_api_name,

Line 2914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2910: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2912: G_MODULE||l_api_name,
2913: 'Parameter p_sync_mode : '||p_sync_mode);
2914: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2915: G_MODULE||l_api_name,
2916: 'p_org_id '||p_org_id);
2917: END IF;
2918:

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

2985: END IF; -- x_request_id is 0
2986:
2987:
2988: -- end debug log
2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: 'x_request_id : '||x_request_id);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2986:
2987:
2988: -- end debug log
2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: 'x_request_id : '||x_request_id);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2994: G_MODULE||l_api_name,

Line 2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: 'x_request_id : '||x_request_id);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2994: G_MODULE||l_api_name,
2995: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2996: END IF;
2997:

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

2996: END IF;
2997:
2998: EXCEPTION
2999: WHEN FND_API.G_EXC_ERROR THEN
3000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3001: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3002: G_MODULE||l_api_name,
3003: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3004: END IF;

Line 3001: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2997:
2998: EXCEPTION
2999: WHEN FND_API.G_EXC_ERROR THEN
3000: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3001: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3002: G_MODULE||l_api_name,
3003: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3004: END IF;
3005:

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

3006: x_return_status := G_RET_STS_ERROR ;
3007: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3008:
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3011: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3012: G_MODULE||l_api_name,
3013: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3014: END IF;

Line 3011: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3007: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3008:
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3011: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3012: G_MODULE||l_api_name,
3013: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3014: END IF;
3015:

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

3016: x_return_status := G_RET_STS_UNEXP_ERROR ;
3017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3018:
3019: WHEN OTHERS THEN
3020: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3022: G_MODULE||l_api_name,
3023: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3024: END IF;

Line 3021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3018:
3019: WHEN OTHERS THEN
3020: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3022: G_MODULE||l_api_name,
3023: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3024: END IF;
3025: