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

APPS.OKC_TERMS_QA_PVT dependencies on FND_LOG

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

316: CURSOR l_seq_csr IS
317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;
318:
319: BEGIN
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');
322: END IF;
323:
324: OPEN l_seq_csr;

Line 321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');

317: SELECT OKC_QA_ERRORS_T_S.NEXTVAL FROM DUAL;
318:
319: BEGIN
320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered get_seq_id');
322: END IF;
323:
324: OPEN l_seq_csr;
325: FETCH l_seq_csr INTO x_sequence_id ;

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

327: RAISE NO_DATA_FOUND;
328: END IF;
329: CLOSE l_seq_csr;
330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving get_seq_id');
333: END IF;
334: RETURN G_RET_STS_SUCCESS;
335: EXCEPTION

Line 332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving get_seq_id');

328: END IF;
329: CLOSE l_seq_csr;
330:
331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving get_seq_id');
333: END IF;
334: RETURN G_RET_STS_SUCCESS;
335: EXCEPTION
336: WHEN OTHERS THEN

Line 338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

334: RETURN G_RET_STS_SUCCESS;
335: EXCEPTION
336: WHEN OTHERS THEN
337:
338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);
340: END IF;
341:
342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);

335: EXCEPTION
336: WHEN OTHERS THEN
337:
338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving get_seq_id because of EXCEPTION: '||sqlerrm);
340: END IF;
341:
342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

383: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
384:
385: BEGIN
386:
387: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Insert_Row function');
389: END IF;
390:
391: INSERT INTO OKC_QA_ERRORS_T

Line 388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Insert_Row function');

384:
385: BEGIN
386:
387: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Entered Insert_Row function');
389: END IF;
390:
391: INSERT INTO OKC_QA_ERRORS_T
392: (

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

440: p_error_record_type_name,
441: p_error_severity_name
442: );
443:
444: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
445: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Leaving Insert_Row');
446: END IF;
447:
448: RETURN( G_RET_STS_SUCCESS );

Line 445: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Leaving Insert_Row');

441: p_error_severity_name
442: );
443:
444: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
445: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'800: Leaving Insert_Row');
446: END IF;
447:
448: RETURN( G_RET_STS_SUCCESS );
449:

Line 453: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

449:
450: EXCEPTION
451: WHEN OTHERS THEN
452:
453: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Insert_Row:OTHERS Exception');
455: END IF;
456:
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Insert_Row:OTHERS Exception');

450: EXCEPTION
451: WHEN OTHERS THEN
452:
453: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Insert_Row:OTHERS Exception');
455: END IF;
456:
457: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
458: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 550: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : OKC_API.G_EXCEPTION_ERROR Exception');
552: END IF;
553: x_return_status := G_RET_STS_ERROR ;
554:

Line 551: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : OKC_API.G_EXCEPTION_ERROR Exception');

547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : OKC_API.G_EXCEPTION_ERROR Exception');
552: END IF;
553: x_return_status := G_RET_STS_ERROR ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

552: END IF;
553: x_return_status := G_RET_STS_ERROR ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');
558: END IF;
559: x_return_status := G_RET_STS_UNEXP_ERROR ;
560:

Line 557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');

553: x_return_status := G_RET_STS_ERROR ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');
558: END IF;
559: x_return_status := G_RET_STS_UNEXP_ERROR ;
560:
561: WHEN OTHERS THEN

Line 562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

558: END IF;
559: x_return_status := G_RET_STS_UNEXP_ERROR ;
560:
561: WHEN OTHERS THEN
562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving get_qa_code_detail:OTHERS Exception');
564: END IF;
565:
566: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving get_qa_code_detail:OTHERS Exception');

559: x_return_status := G_RET_STS_UNEXP_ERROR ;
560:
561: WHEN OTHERS THEN
562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving get_qa_code_detail:OTHERS Exception');
564: END IF;
565:
566: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

582: l_api_name CONSTANT VARCHAR2(30) := 'log_qa_messages';
583: i NUMBER ;
584:
585: BEGIN
586: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered log_qa_messages');
588: END IF;
589: -- Initialize API return status to success
590: x_return_status := G_RET_STS_SUCCESS;

Line 587: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered log_qa_messages');

583: i NUMBER ;
584:
585: BEGIN
586: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Entered log_qa_messages');
588: END IF;
589: -- Initialize API return status to success
590: x_return_status := G_RET_STS_SUCCESS;
591:

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

639:
640: END LOOP; -- FOR i IN p_qa_result_tbl.FIRST..p_qa_result_tbl.LAST LOOP
641: END IF; -- If p_qa_result_tbl.COUNT > 0 THEN
642:
643: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Leaving log_qa_messages');
645: END IF;
646:
647: EXCEPTION

Line 644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Leaving log_qa_messages');

640: END LOOP; -- FOR i IN p_qa_result_tbl.FIRST..p_qa_result_tbl.LAST LOOP
641: END IF; -- If p_qa_result_tbl.COUNT > 0 THEN
642:
643: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Leaving log_qa_messages');
645: END IF;
646:
647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN

Line 649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

645: END IF;
646:
647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN
649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');
651: END IF;
652: x_return_status := G_RET_STS_ERROR ;
653:

Line 650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');

646:
647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN
649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');
651: END IF;
652: x_return_status := G_RET_STS_ERROR ;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 655: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

651: END IF;
652: x_return_status := G_RET_STS_ERROR ;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
657: END IF;
658: x_return_status := G_RET_STS_UNEXP_ERROR ;
659:

Line 656: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

652: x_return_status := G_RET_STS_ERROR ;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
657: END IF;
658: x_return_status := G_RET_STS_UNEXP_ERROR ;
659:
660: WHEN OTHERS THEN

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

657: END IF;
658: x_return_status := G_RET_STS_UNEXP_ERROR ;
659:
660: WHEN OTHERS THEN
661: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Log_QA_Messages because of EXCEPTION: '||sqlerrm);
663: END IF;
664: x_return_status := G_RET_STS_UNEXP_ERROR ;
665:

Line 662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Log_QA_Messages because of EXCEPTION: '||sqlerrm);

658: x_return_status := G_RET_STS_UNEXP_ERROR ;
659:
660: WHEN OTHERS THEN
661: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving Log_QA_Messages because of EXCEPTION: '||sqlerrm);
663: END IF;
664: x_return_status := G_RET_STS_UNEXP_ERROR ;
665:
666: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

741: */
742:
743: BEGIN
744:
745: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Incomp_and_alternate');
747: END IF;
748:
749: -- current Org Id

Line 746: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Incomp_and_alternate');

742:
743: BEGIN
744:
745: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Incomp_and_alternate');
747: END IF;
748:
749: -- current Org Id
750: -- fnd_profile.get('ORG_ID',l_current_org_id);

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

749: -- current Org Id
750: -- fnd_profile.get('ORG_ID',l_current_org_id);
751: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);
752:
753: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);
755: END IF;
756:
757: get_qa_code_detail(p_qa_code => G_CHECK_INCOMPATIBILITY,

Line 754: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);

750: -- fnd_profile.get('ORG_ID',l_current_org_id);
751: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);
752:
753: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);
755: END IF;
756:
757: get_qa_code_detail(p_qa_code => G_CHECK_INCOMPATIBILITY,
758: x_perform_qa => l_perform_incom_qa,

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

889: */
890:
891: END IF;-- IF l_perform_incom_QA ='Y' OR l_perform_alternate_QA='Y'
892:
893: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
895: END IF;
896:
897: EXCEPTION

Line 894: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');

890:
891: END IF;-- IF l_perform_incom_QA ='Y' OR l_perform_alternate_QA='Y'
892:
893: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
895: END IF;
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN

Line 899: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

895: END IF;
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
901: END IF;
902:
903: IF l_get_incomp_alter_csr%ISOPEN THEN

Line 900: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');

896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
901: END IF;
902:
903: IF l_get_incomp_alter_csr%ISOPEN THEN
904: CLOSE l_get_incomp_alter_csr;

Line 915: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

911:
912: x_return_status := G_RET_STS_ERROR ;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
917: END IF;
918:
919: IF l_get_incomp_alter_csr%ISOPEN THEN

Line 916: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

912: x_return_status := G_RET_STS_ERROR ;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
917: END IF;
918:
919: IF l_get_incomp_alter_csr%ISOPEN THEN
920: CLOSE l_get_incomp_alter_csr;

Line 931: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

927:
928: x_return_status := G_RET_STS_UNEXP_ERROR ;
929:
930: WHEN OTHERS THEN
931: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
933: END IF;
934:
935: IF l_get_incomp_alter_csr%ISOPEN THEN

Line 932: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);

928: x_return_status := G_RET_STS_UNEXP_ERROR ;
929:
930: WHEN OTHERS THEN
931: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
933: END IF;
934:
935: IF l_get_incomp_alter_csr%ISOPEN THEN
936: CLOSE l_get_incomp_alter_csr;

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

990:
991:
992: BEGIN
993:
994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_lock_contract');
996: END IF;
997:
998: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_lock_contract');

991:
992: BEGIN
993:
994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_lock_contract');
996: END IF;
997:
998: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_lock_contract : '||l_lock_contract);

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

994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_lock_contract');
996: END IF;
997:
998: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_lock_contract : '||l_lock_contract);
1000: END IF;
1001:
1002: -- Initialize API return status to success

Line 999: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_lock_contract : '||l_lock_contract);

995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_lock_contract');
996: END IF;
997:
998: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
999: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_lock_contract : '||l_lock_contract);
1000: END IF;
1001:
1002: -- Initialize API return status to success
1003: x_return_status := G_RET_STS_SUCCESS;

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

1048: END IF; -- IF (l_lock_contract = 'Y')
1049:
1050: END IF;-- IF l_perform_lock_QA ='Y'
1051:
1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1054: END IF;
1055:
1056: EXCEPTION

Line 1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');

1049:
1050: END IF;-- IF l_perform_lock_QA ='Y'
1051:
1052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN

Line 1058: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1060: END IF;
1061:
1062: x_return_status := G_RET_STS_ERROR ;

Line 1059: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');

1055:
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1060: END IF;
1061:
1062: x_return_status := G_RET_STS_ERROR ;
1063:

Line 1065: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1061:
1062: x_return_status := G_RET_STS_ERROR ;
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1067: END IF;
1068:
1069: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1066: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1062: x_return_status := G_RET_STS_ERROR ;
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1067: END IF;
1068:
1069: x_return_status := G_RET_STS_UNEXP_ERROR ;
1070:

Line 1072: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1068:
1069: x_return_status := G_RET_STS_UNEXP_ERROR ;
1070:
1071: WHEN OTHERS THEN
1072: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1074: END IF;
1075:
1076: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1073: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);

1069: x_return_status := G_RET_STS_UNEXP_ERROR ;
1070:
1071: WHEN OTHERS THEN
1072: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1074: END IF;
1075:
1076: x_return_status := G_RET_STS_UNEXP_ERROR ;
1077:

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

1158: and adminppl.effective_start_date = adminppl.start_date;
1159:
1160: BEGIN
1161:
1162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1164: END IF;
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');

1159:
1160: BEGIN
1161:
1162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1164: END IF;
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);

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

1162: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1164: END IF;
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);
1168:
1169: END IF;
1170:

Line 1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);

1163: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1164: END IF;
1165:
1166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);
1168:
1169: END IF;
1170:
1171: -- Initialize API return status to success

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

1297: END IF; -- IF (l_ctrt_admin = 'Y')
1298:
1299: END IF;-- IF l_perform_ctrt_admin_qa ='Y'
1300:
1301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1303: END IF;
1304:
1305: EXCEPTION

Line 1302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');

1298:
1299: END IF;-- IF l_perform_ctrt_admin_qa ='Y'
1300:
1301: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1303: END IF;
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN

Line 1307: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1303: END IF;
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1308: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1309: END IF;
1310:
1311: x_return_status := G_RET_STS_ERROR ;

Line 1308: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');

1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1308: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1309: END IF;
1310:
1311: x_return_status := G_RET_STS_ERROR ;
1312:

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

1310:
1311: x_return_status := G_RET_STS_ERROR ;
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1316: END IF;
1317:
1318: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1315: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1311: x_return_status := G_RET_STS_ERROR ;
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1316: END IF;
1317:
1318: x_return_status := G_RET_STS_UNEXP_ERROR ;
1319:

Line 1321: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1317:
1318: x_return_status := G_RET_STS_UNEXP_ERROR ;
1319:
1320: WHEN OTHERS THEN
1321: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1323: END IF;
1324:
1325: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1322: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);

1318: x_return_status := G_RET_STS_UNEXP_ERROR ;
1319:
1320: WHEN OTHERS THEN
1321: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1322: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1323: END IF;
1324:
1325: x_return_status := G_RET_STS_UNEXP_ERROR ;
1326:

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

1366: */
1367:
1368: BEGIN
1369:
1370: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_duplicate_articles');
1372: END IF;
1373:
1374: get_qa_code_detail(p_qa_code => 'CHECK_DUPLICATE',

Line 1371: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_duplicate_articles');

1367:
1368: BEGIN
1369:
1370: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_duplicate_articles');
1372: END IF;
1373:
1374: get_qa_code_detail(p_qa_code => 'CHECK_DUPLICATE',
1375: x_perform_qa => l_perform_duplicate_qa,

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

1390: END IF;
1391:
1392: IF l_article_tbl.COUNT > 0 THEN
1393:
1394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: totally:'||l_article_tbl.COUNT||' articles to check');
1396: END IF;
1397:
1398: FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP

Line 1395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: totally:'||l_article_tbl.COUNT||' articles to check');

1391:
1392: IF l_article_tbl.COUNT > 0 THEN
1393:
1394: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1395: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: totally:'||l_article_tbl.COUNT||' articles to check');
1396: END IF;
1397:
1398: FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1399:

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

1405:
1406: --Bug 4128923 l_error_count := 0;
1407:
1408: FOR k IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1409: --IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1410: -- FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', k:'||k);
1411: --END IF;
1412:
1413: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1410: -- FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', k:'||k);

1406: --Bug 4128923 l_error_count := 0;
1407:
1408: FOR k IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1409: --IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1410: -- FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', k:'||k);
1411: --END IF;
1412:
1413: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
1414: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)

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

1413: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
1414: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)
1415: =Nvl(l_article_tbl(i).std_art_id,l_article_tbl(i).article_id) THEN
1416:
1417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Dupicate found - i:'||i||', k:'||k);
1419: END IF;
1420: l_error_count := l_error_count + 1;
1421: END IF;

Line 1418: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Dupicate found - i:'||i||', k:'||k);

1414: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)
1415: =Nvl(l_article_tbl(i).std_art_id,l_article_tbl(i).article_id) THEN
1416:
1417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1418: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Dupicate found - i:'||i||', k:'||k);
1419: END IF;
1420: l_error_count := l_error_count + 1;
1421: END IF;
1422: END LOOP; -- FOR k IN l_article_tbl1.FIRST..l_article_tbl1.LAST LOOP

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

1474: END IF; -- IF l_article_tbl.COUNT > 0 THEN
1475:
1476: END IF; -- IF l_perform_duplicate_qa ='Y' THEN
1477:
1478: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1480: END IF;
1481:
1482: EXCEPTION

Line 1479: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');

1475:
1476: END IF; -- IF l_perform_duplicate_qa ='Y' THEN
1477:
1478: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1480: END IF;
1481:
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN

Line 1484: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1480: END IF;
1481:
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1486: END IF;
1487:
1488: /* expert commented out

Line 1485: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');

1481:
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1486: END IF;
1487:
1488: /* expert commented out
1489: IF l_get_dup_xprt_csr%ISOPEN THEN

Line 1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1493:
1494: x_return_status := G_RET_STS_ERROR ;
1495:
1496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1499: END IF;
1500:
1501: /* expert commented out

Line 1498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1494: x_return_status := G_RET_STS_ERROR ;
1495:
1496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1499: END IF;
1500:
1501: /* expert commented out
1502: IF l_get_dup_xprt_csr%ISOPEN THEN

Line 1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1505: */
1506: x_return_status := G_RET_STS_UNEXP_ERROR ;
1507:
1508: WHEN OTHERS THEN
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_duplicate_articles because of EXCEPTION: '||sqlerrm);
1511: END IF;
1512:
1513: /* expert commented out

Line 1510: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_duplicate_articles because of EXCEPTION: '||sqlerrm);

1506: x_return_status := G_RET_STS_UNEXP_ERROR ;
1507:
1508: WHEN OTHERS THEN
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_duplicate_articles because of EXCEPTION: '||sqlerrm);
1511: END IF;
1512:
1513: /* expert commented out
1514: IF l_get_dup_xprt_csr%ISOPEN THEN

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

1733: */
1734:
1735: BEGIN
1736:
1737: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1738: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_var_doc_type_usage');
1739: END IF;
1740:
1741: get_qa_code_detail(p_qa_code => G_CHECK_VAR_USAGE,

Line 1738: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_var_doc_type_usage');

1734:
1735: BEGIN
1736:
1737: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1738: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_var_doc_type_usage');
1739: END IF;
1740:
1741: get_qa_code_detail(p_qa_code => G_CHECK_VAR_USAGE,
1742: x_perform_qa => l_perform_var_usg_qa,

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

1826:
1827: END IF; -- IF l_perform_var_usg_qa ='Y' THEN
1828:
1829:
1830: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1832: END IF;
1833:
1834: EXCEPTION

Line 1831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');

1827: END IF; -- IF l_perform_var_usg_qa ='Y' THEN
1828:
1829:
1830: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN

Line 1836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_ERROR Exception');
1838: END IF;
1839:
1840: IF l_check_usage_csr%ISOPEN THEN

Line 1837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_ERROR Exception');

1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_ERROR Exception');
1838: END IF;
1839:
1840: IF l_check_usage_csr%ISOPEN THEN
1841: CLOSE l_check_usage_csr ;

Line 1853: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1849:
1850: x_return_status := G_RET_STS_ERROR ;
1851:
1852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1853: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1854: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1855: END IF;
1856:
1857: IF l_check_usage_csr%ISOPEN THEN

Line 1854: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1850: x_return_status := G_RET_STS_ERROR ;
1851:
1852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1853: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1854: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1855: END IF;
1856:
1857: IF l_check_usage_csr%ISOPEN THEN
1858: CLOSE l_check_usage_csr ;

Line 1870: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1866:
1867: x_return_status := G_RET_STS_UNEXP_ERROR ;
1868:
1869: WHEN OTHERS THEN
1870: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1871: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_var_doc_type_usage because of EXCEPTION: '||sqlerrm);
1872: END IF;
1873:
1874: IF l_check_usage_csr%ISOPEN THEN

Line 1871: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_var_doc_type_usage because of EXCEPTION: '||sqlerrm);

1867: x_return_status := G_RET_STS_UNEXP_ERROR ;
1868:
1869: WHEN OTHERS THEN
1870: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1871: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_var_doc_type_usage because of EXCEPTION: '||sqlerrm);
1872: END IF;
1873:
1874: IF l_check_usage_csr%ISOPEN THEN
1875: CLOSE l_check_usage_csr ;

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

1929: ORDER BY VB.variable_code;
1930:
1931:
1932: BEGIN
1933: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_user_vars_with_procs');
1935: END IF;
1936:
1937: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,

Line 1934: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_user_vars_with_procs');

1930:
1931:
1932: BEGIN
1933: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_user_vars_with_procs');
1935: END IF;
1936:
1937: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,
1938: x_perform_qa => l_perform_int_qa,

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

1990:
1991: END LOOP;
1992:
1993:
1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1996: END IF;
1997:
1998: EXCEPTION

Line 1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');

1991: END LOOP;
1992:
1993:
1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1996: END IF;
1997:
1998: EXCEPTION
1999: WHEN FND_API.G_EXC_ERROR THEN

Line 2000: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1996: END IF;
1997:
1998: EXCEPTION
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_ERROR Exception');
2002: END IF;
2003:
2004: IF csr_get_udv_with_procs%ISOPEN THEN

Line 2001: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_ERROR Exception');

1997:
1998: EXCEPTION
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_ERROR Exception');
2002: END IF;
2003:
2004: IF csr_get_udv_with_procs%ISOPEN THEN
2005: CLOSE csr_get_udv_with_procs;

Line 2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2007:
2008: x_return_status := G_RET_STS_ERROR ;
2009:
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2013: END IF;
2014:
2015: IF csr_get_udv_with_procs%ISOPEN THEN

Line 2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2008: x_return_status := G_RET_STS_ERROR ;
2009:
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2013: END IF;
2014:
2015: IF csr_get_udv_with_procs%ISOPEN THEN
2016: CLOSE csr_get_udv_with_procs;

Line 2022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2018:
2019: x_return_status := G_RET_STS_UNEXP_ERROR ;
2020:
2021: WHEN OTHERS THEN
2022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving check_user_vars_with_procs because of EXCEPTION: '||sqlerrm);
2024: END IF;
2025:
2026: IF csr_get_udv_with_procs%ISOPEN THEN

Line 2023: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving check_user_vars_with_procs because of EXCEPTION: '||sqlerrm);

2019: x_return_status := G_RET_STS_UNEXP_ERROR ;
2020:
2021: WHEN OTHERS THEN
2022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving check_user_vars_with_procs because of EXCEPTION: '||sqlerrm);
2024: END IF;
2025:
2026: IF csr_get_udv_with_procs%ISOPEN THEN
2027: CLOSE csr_get_udv_with_procs;

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

2094:
2095:
2096: BEGIN
2097:
2098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_variables');
2100: END IF;
2101:
2102: get_qa_code_detail(p_qa_code => G_CHECK_UNRESOLVED_SYS_VAR,

Line 2099: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_variables');

2095:
2096: BEGIN
2097:
2098: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_variables');
2100: END IF;
2101:
2102: get_qa_code_detail(p_qa_code => G_CHECK_UNRESOLVED_SYS_VAR,
2103: x_perform_qa => l_perform_sys_qa ,

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

2253:
2254: END IF; -- IF l_perform_int_QA='Y' or l_perform_ext_qa='Y' or l_perf
2255:
2256:
2257: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2259: END IF;
2260:
2261: EXCEPTION

Line 2258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');

2254: END IF; -- IF l_perform_int_QA='Y' or l_perform_ext_qa='Y' or l_perf
2255:
2256:
2257: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN FND_API.G_EXC_ERROR THEN

Line 2263: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN FND_API.G_EXC_ERROR THEN
2263: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2264: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2265: END IF;
2266:
2267: IF l_check_variable_csr%ISOPEN THEN

Line 2264: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');

2260:
2261: EXCEPTION
2262: WHEN FND_API.G_EXC_ERROR THEN
2263: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2264: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2265: END IF;
2266:
2267: IF l_check_variable_csr%ISOPEN THEN
2268: CLOSE l_check_variable_csr;

Line 2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2270:
2271: x_return_status := G_RET_STS_ERROR ;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2276: END IF;
2277:
2278: IF l_check_variable_csr%ISOPEN THEN

Line 2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2271: x_return_status := G_RET_STS_ERROR ;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2276: END IF;
2277:
2278: IF l_check_variable_csr%ISOPEN THEN
2279: CLOSE l_check_variable_csr;

Line 2285: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2281:
2282: x_return_status := G_RET_STS_UNEXP_ERROR ;
2283:
2284: WHEN OTHERS THEN
2285: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_variables because of EXCEPTION: '||sqlerrm);
2287: END IF;
2288:
2289: IF l_check_variable_csr%ISOPEN THEN

Line 2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_variables because of EXCEPTION: '||sqlerrm);

2282: x_return_status := G_RET_STS_UNEXP_ERROR ;
2283:
2284: WHEN OTHERS THEN
2285: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_variables because of EXCEPTION: '||sqlerrm);
2287: END IF;
2288:
2289: IF l_check_variable_csr%ISOPEN THEN
2290: CLOSE l_check_variable_csr;

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

2326: AND nvl(kart.summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED;
2327:
2328: BEGIN
2329:
2330: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_unassigned_articles');
2332: END IF;
2333:
2334: get_qa_code_detail(p_qa_code => G_CHECK_UNASSIGNED_ART,

Line 2331: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_unassigned_articles');

2327:
2328: BEGIN
2329:
2330: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2331: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_unassigned_articles');
2332: END IF;
2333:
2334: get_qa_code_detail(p_qa_code => G_CHECK_UNASSIGNED_ART,
2335: x_perform_qa => l_perform_unas_art_qa,

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

2362:
2363: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2364: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2365:
2366: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2368: END IF;
2369:
2370: EXCEPTION

Line 2367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');

2363: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2364: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2365:
2366: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2368: END IF;
2369:
2370: EXCEPTION
2371: WHEN FND_API.G_EXC_ERROR THEN

Line 2372: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2368: END IF;
2369:
2370: EXCEPTION
2371: WHEN FND_API.G_EXC_ERROR THEN
2372: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2374: END IF;
2375:
2376: IF l_get_unass_art_crs%ISOPEN THEN

Line 2373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');

2369:
2370: EXCEPTION
2371: WHEN FND_API.G_EXC_ERROR THEN
2372: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2374: END IF;
2375:
2376: IF l_get_unass_art_crs%ISOPEN THEN
2377: CLOSE l_get_unass_art_crs;

Line 2383: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2379:
2380: x_return_status := G_RET_STS_ERROR ;
2381:
2382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2383: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2384: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2385: END IF;
2386:
2387: IF l_get_unass_art_crs%ISOPEN THEN

Line 2384: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2380: x_return_status := G_RET_STS_ERROR ;
2381:
2382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2383: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2384: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2385: END IF;
2386:
2387: IF l_get_unass_art_crs%ISOPEN THEN
2388: CLOSE l_get_unass_art_crs;

Line 2394: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2390:
2391: x_return_status := G_RET_STS_UNEXP_ERROR ;
2392:
2393: WHEN OTHERS THEN
2394: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_unassigned_articles because of EXCEPTION: '||sqlerrm);
2396: END IF;
2397:
2398: IF l_get_unass_art_crs%ISOPEN THEN

Line 2395: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_unassigned_articles because of EXCEPTION: '||sqlerrm);

2391: x_return_status := G_RET_STS_UNEXP_ERROR ;
2392:
2393: WHEN OTHERS THEN
2394: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2395: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_unassigned_articles because of EXCEPTION: '||sqlerrm);
2396: END IF;
2397:
2398: IF l_get_unass_art_crs%ISOPEN THEN
2399: CLOSE l_get_unass_art_crs;

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

2436: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED);
2437: -- if section has sub sections then it is not considered empty Bug 3219528
2438: BEGIN
2439:
2440: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_empty_sections');
2442: END IF;
2443:
2444: get_qa_code_detail(p_qa_code => G_CHECK_EMPTY_SECTION,

Line 2441: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_empty_sections');

2437: -- if section has sub sections then it is not considered empty Bug 3219528
2438: BEGIN
2439:
2440: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_empty_sections');
2442: END IF;
2443:
2444: get_qa_code_detail(p_qa_code => G_CHECK_EMPTY_SECTION,
2445: x_perform_qa => l_perform_empty_scn_qa,

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

2472:
2473: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2474: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2475:
2476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2478: END IF;
2479:
2480: EXCEPTION

Line 2477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');

2473: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2474: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2475:
2476: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2478: END IF;
2479:
2480: EXCEPTION
2481: WHEN FND_API.G_EXC_ERROR THEN

Line 2482: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2478: END IF;
2479:
2480: EXCEPTION
2481: WHEN FND_API.G_EXC_ERROR THEN
2482: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2483: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2484: END IF;
2485:
2486: IF l_get_empty_section_csr%ISOPEN THEN

Line 2483: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');

2479:
2480: EXCEPTION
2481: WHEN FND_API.G_EXC_ERROR THEN
2482: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2483: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2484: END IF;
2485:
2486: IF l_get_empty_section_csr%ISOPEN THEN
2487: CLOSE l_get_empty_section_csr;

Line 2493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2489:
2490: x_return_status := G_RET_STS_ERROR ;
2491:
2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2494: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2495: END IF;
2496:
2497: IF l_get_empty_section_csr%ISOPEN THEN

Line 2494: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2490: x_return_status := G_RET_STS_ERROR ;
2491:
2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2494: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2495: END IF;
2496:
2497: IF l_get_empty_section_csr%ISOPEN THEN
2498: CLOSE l_get_empty_section_csr;

Line 2504: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2500:
2501: x_return_status := G_RET_STS_UNEXP_ERROR ;
2502:
2503: WHEN OTHERS THEN
2504: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2505: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_empty_sections because of EXCEPTION: '||sqlerrm);
2506: END IF;
2507:
2508: IF l_get_empty_section_csr%ISOPEN THEN

Line 2505: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_empty_sections because of EXCEPTION: '||sqlerrm);

2501: x_return_status := G_RET_STS_UNEXP_ERROR ;
2502:
2503: WHEN OTHERS THEN
2504: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2505: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_empty_sections because of EXCEPTION: '||sqlerrm);
2506: END IF;
2507:
2508: IF l_get_empty_section_csr%ISOPEN THEN
2509: CLOSE l_get_empty_section_csr;

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

2535: WHERE document_type = p_doc_type;
2536:
2537: BEGIN
2538:
2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Section_Amend_No_Texts');
2541: END IF;
2542:
2543: --Bug 3681462 Check for disable_amend_yn

Line 2540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Section_Amend_No_Texts');

2536:
2537: BEGIN
2538:
2539: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Section_Amend_No_Texts');
2541: END IF;
2542:
2543: --Bug 3681462 Check for disable_amend_yn
2544: OPEN l_get_doc_disable_amend_csr;

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

2585: END IF; -- IF l_perform_scn_amend_qa='Y' THEN
2586:
2587: END IF; -- l_disable_amend_yn = 'N'
2588:
2589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2591: END IF;
2592:
2593: EXCEPTION

Line 2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');

2586:
2587: END IF; -- l_disable_amend_yn = 'N'
2588:
2589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN

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

2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2596: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_ERROR Exception');
2597: END IF;
2598:
2599: x_return_status := G_RET_STS_ERROR ;

Line 2596: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_ERROR Exception');

2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2596: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_ERROR Exception');
2597: END IF;
2598:
2599: x_return_status := G_RET_STS_ERROR ;
2600:

Line 2602: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2598:
2599: x_return_status := G_RET_STS_ERROR ;
2600:
2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2602: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2603: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2604: END IF;
2605:
2606: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2603: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2599: x_return_status := G_RET_STS_ERROR ;
2600:
2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2602: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2603: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2604: END IF;
2605:
2606: x_return_status := G_RET_STS_UNEXP_ERROR ;
2607:

Line 2609: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2605:
2606: x_return_status := G_RET_STS_UNEXP_ERROR ;
2607:
2608: WHEN OTHERS THEN
2609: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2610: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Section_Amend_No_Texts because of EXCEPTION: '||sqlerrm);
2611: END IF;
2612:
2613: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2610: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Section_Amend_No_Texts because of EXCEPTION: '||sqlerrm);

2606: x_return_status := G_RET_STS_UNEXP_ERROR ;
2607:
2608: WHEN OTHERS THEN
2609: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2610: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Section_Amend_No_Texts because of EXCEPTION: '||sqlerrm);
2611: END IF;
2612:
2613: x_return_status := G_RET_STS_UNEXP_ERROR ;
2614: END check_section_amend_no_texts;

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

2636: WHERE document_type = p_doc_type;
2637:
2638: BEGIN
2639:
2640: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_article_amend_no_texts');
2642: END IF;
2643:
2644: --Bug 3681462 Check for disable_amend_yn

Line 2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_article_amend_no_texts');

2637:
2638: BEGIN
2639:
2640: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_article_amend_no_texts');
2642: END IF;
2643:
2644: --Bug 3681462 Check for disable_amend_yn
2645: OPEN l_get_doc_disable_amend_csr;

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

2689: END IF; -- IF l_perform_art_amend_qa ='Y' THEN
2690:
2691: END IF; -- l_disable_amend_yn = 'N'
2692:
2693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2695: END IF;
2696:
2697: EXCEPTION

Line 2694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');

2690:
2691: END IF; -- l_disable_amend_yn = 'N'
2692:
2693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2695: END IF;
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN

Line 2699: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2695: END IF;
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_ERROR Exception');
2701: END IF;
2702:
2703: x_return_status := G_RET_STS_ERROR ;

Line 2700: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_ERROR Exception');

2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_ERROR Exception');
2701: END IF;
2702:
2703: x_return_status := G_RET_STS_ERROR ;
2704:

Line 2706: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2702:
2703: x_return_status := G_RET_STS_ERROR ;
2704:
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2707: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2708: END IF;
2709:
2710: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2707: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2703: x_return_status := G_RET_STS_ERROR ;
2704:
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2707: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2708: END IF;
2709:
2710: x_return_status := G_RET_STS_UNEXP_ERROR ;
2711:

Line 2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2709:
2710: x_return_status := G_RET_STS_UNEXP_ERROR ;
2711:
2712: WHEN OTHERS THEN
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_article_amend_no_texts because of EXCEPTION: '||sqlerrm);
2715: END IF;
2716:
2717: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_article_amend_no_texts because of EXCEPTION: '||sqlerrm);

2710: x_return_status := G_RET_STS_UNEXP_ERROR ;
2711:
2712: WHEN OTHERS THEN
2713: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2714: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_article_amend_no_texts because of EXCEPTION: '||sqlerrm);
2715: END IF;
2716:
2717: x_return_status := G_RET_STS_UNEXP_ERROR ;
2718: END check_article_amend_no_texts;

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

2764: AND LANGUAGE = userenv('LANG');
2765:
2766: BEGIN
2767:
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_inactive_template');
2770: END IF;
2771:
2772: get_qa_code_detail(p_qa_code => G_CHECK_TMPL_EFFECTIVITY,

Line 2769: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_inactive_template');

2765:
2766: BEGIN
2767:
2768: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2769: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_inactive_template');
2770: END IF;
2771:
2772: get_qa_code_detail(p_qa_code => G_CHECK_TMPL_EFFECTIVITY,
2773: x_perform_qa => l_perform_tmpl_qa,

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

2833: END LOOP; -- FOR cr in l_get_template_crs LOOP
2834: END IF; -- IF l_perform_tmpl_qa ='Y' THEN
2835:
2836:
2837: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');
2839: END IF;
2840:
2841: EXCEPTION

Line 2838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');

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

Line 2843: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2839: END IF;
2840:
2841: EXCEPTION
2842: WHEN FND_API.G_EXC_ERROR THEN
2843: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2845: END IF;
2846:
2847: IF l_get_template_crs%ISOPEN THEN

Line 2844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');

2840:
2841: EXCEPTION
2842: WHEN FND_API.G_EXC_ERROR THEN
2843: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2845: END IF;
2846:
2847: IF l_get_template_crs%ISOPEN THEN
2848: CLOSE l_get_template_crs;

Line 2854: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2850:
2851: x_return_status := G_RET_STS_ERROR ;
2852:
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2855: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2856: END IF;
2857:
2858: IF l_get_template_crs%ISOPEN THEN

Line 2855: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2851: x_return_status := G_RET_STS_ERROR ;
2852:
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2855: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2856: END IF;
2857:
2858: IF l_get_template_crs%ISOPEN THEN
2859: CLOSE l_get_template_crs;

Line 2865: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2861:
2862: x_return_status := G_RET_STS_UNEXP_ERROR ;
2863:
2864: WHEN OTHERS THEN
2865: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2866: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_inactive_template because of EXCEPTION: '||sqlerrm);
2867: END IF;
2868:
2869: IF l_get_template_crs%ISOPEN THEN

Line 2866: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_inactive_template because of EXCEPTION: '||sqlerrm);

2862: x_return_status := G_RET_STS_UNEXP_ERROR ;
2863:
2864: WHEN OTHERS THEN
2865: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2866: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_inactive_template because of EXCEPTION: '||sqlerrm);
2867: END IF;
2868:
2869: IF l_get_template_crs%ISOPEN THEN
2870: CLOSE l_get_template_crs;

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

3082: ) ;
3083:
3084: BEGIN
3085:
3086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_art_effectivity');
3088: END IF;
3089:
3090: get_qa_code_detail(p_qa_code => G_CHECK_ART_VALIDITY,

Line 3087: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_art_effectivity');

3083:
3084: BEGIN
3085:
3086: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_art_effectivity');
3088: END IF;
3089:
3090: get_qa_code_detail(p_qa_code => G_CHECK_ART_VALIDITY,
3091: x_perform_qa => l_perform_art_val_qa,

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

3258:
3259: END IF; -- IF l_perform_art_val_qa='Y' OR l_perform_lat_vers_qa='Y'
3260:
3261:
3262: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3264: END IF;
3265:
3266: EXCEPTION

Line 3263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');

3259: END IF; -- IF l_perform_art_val_qa='Y' OR l_perform_lat_vers_qa='Y'
3260:
3261:
3262: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3264: END IF;
3265:
3266: EXCEPTION
3267: WHEN FND_API.G_EXC_ERROR THEN

Line 3268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3264: END IF;
3265:
3266: EXCEPTION
3267: WHEN FND_API.G_EXC_ERROR THEN
3268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3270: END IF;
3271:
3272: IF l_get_tmpl_dates_csr%ISOPEN THEN

Line 3269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');

3265:
3266: EXCEPTION
3267: WHEN FND_API.G_EXC_ERROR THEN
3268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3270: END IF;
3271:
3272: IF l_get_tmpl_dates_csr%ISOPEN THEN
3273: CLOSE l_get_tmpl_dates_csr;

Line 3294: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3290:
3291: x_return_status := G_RET_STS_ERROR ;
3292:
3293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3294: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3295: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3296: END IF;
3297:
3298: IF l_get_tmpl_dates_csr%ISOPEN THEN

Line 3295: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3291: x_return_status := G_RET_STS_ERROR ;
3292:
3293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3294: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3295: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3296: END IF;
3297:
3298: IF l_get_tmpl_dates_csr%ISOPEN THEN
3299: CLOSE l_get_tmpl_dates_csr;

Line 3320: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3316:
3317: x_return_status := G_RET_STS_UNEXP_ERROR ;
3318:
3319: WHEN OTHERS THEN
3320: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3321: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_art_effectivity because of EXCEPTION: '||sqlerrm);
3322: END IF;
3323:
3324: IF l_get_tmpl_dates_csr%ISOPEN THEN

Line 3321: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_art_effectivity because of EXCEPTION: '||sqlerrm);

3317: x_return_status := G_RET_STS_UNEXP_ERROR ;
3318:
3319: WHEN OTHERS THEN
3320: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3321: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_art_effectivity because of EXCEPTION: '||sqlerrm);
3322: END IF;
3323:
3324: IF l_get_tmpl_dates_csr%ISOPEN THEN
3325: CLOSE l_get_tmpl_dates_csr;

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

3369: WHERE template_id = p_doc_id ;
3370:
3371: BEGIN
3372:
3373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_layout_template');
3375: END IF;
3376: get_qa_code_detail(p_qa_code => G_CHECK_LAYOUT_TMPL,
3377: x_perform_qa => l_perform_layout_tmpl_qa,

Line 3374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_layout_template');

3370:
3371: BEGIN
3372:
3373: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3374: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_layout_template');
3375: END IF;
3376: get_qa_code_detail(p_qa_code => G_CHECK_LAYOUT_TMPL,
3377: x_perform_qa => l_perform_layout_tmpl_qa,
3378: x_qa_name => l_desc,

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

3416: END IF;
3417:
3418: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN
3419:
3420: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3422: END IF;
3423:
3424: EXCEPTION

Line 3421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');

3417:
3418: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN
3419:
3420: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3422: END IF;
3423:
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR THEN

Line 3426: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3422: END IF;
3423:
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR THEN
3426: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3428: END IF;
3429:
3430: IF l_get_layout_tmpl_csr%ISOPEN THEN

Line 3427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');

3423:
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR THEN
3426: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3428: END IF;
3429:
3430: IF l_get_layout_tmpl_csr%ISOPEN THEN
3431: CLOSE l_get_layout_tmpl_csr;

Line 3437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3433:
3434: x_return_status := G_RET_STS_ERROR ;
3435:
3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3439: END IF;
3440:
3441: IF l_get_layout_tmpl_csr%ISOPEN THEN

Line 3438: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3434: x_return_status := G_RET_STS_ERROR ;
3435:
3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3439: END IF;
3440:
3441: IF l_get_layout_tmpl_csr%ISOPEN THEN
3442: CLOSE l_get_layout_tmpl_csr;

Line 3448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3444:
3445: x_return_status := G_RET_STS_UNEXP_ERROR ;
3446:
3447: WHEN OTHERS THEN
3448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_layout_template because of EXCEPTION: '||sqlerrm);
3450: END IF;
3451:
3452: IF l_get_layout_tmpl_csr%ISOPEN THEN

Line 3449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_layout_template because of EXCEPTION: '||sqlerrm);

3445: x_return_status := G_RET_STS_UNEXP_ERROR ;
3446:
3447: WHEN OTHERS THEN
3448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_layout_template because of EXCEPTION: '||sqlerrm);
3450: END IF;
3451:
3452: IF l_get_layout_tmpl_csr%ISOPEN THEN
3453: CLOSE l_get_layout_tmpl_csr;

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

3491:
3492:
3493: BEGIN
3494:
3495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_revision');
3497: END IF;
3498: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_REVISION,
3499: x_perform_qa => l_perform_trans_rev_qa,

Line 3496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_revision');

3492:
3493: BEGIN
3494:
3495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3496: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_revision');
3497: END IF;
3498: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_REVISION,
3499: x_perform_qa => l_perform_trans_rev_qa,
3500: x_qa_name => l_desc,

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

3538: END IF;
3539:
3540: END IF;
3541:
3542: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3544: END IF;
3545:
3546: EXCEPTION

Line 3543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');

3539:
3540: END IF;
3541:
3542: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3544: END IF;
3545:
3546: EXCEPTION
3547: WHEN FND_API.G_EXC_ERROR THEN

Line 3548: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3544: END IF;
3545:
3546: EXCEPTION
3547: WHEN FND_API.G_EXC_ERROR THEN
3548: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3549: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3550: END IF;
3551:
3552: IF l_translated_tmpl_revision_csr%ISOPEN THEN

Line 3549: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');

3545:
3546: EXCEPTION
3547: WHEN FND_API.G_EXC_ERROR THEN
3548: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3549: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3550: END IF;
3551:
3552: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3553: CLOSE l_translated_tmpl_revision_csr;

Line 3559: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3555:
3556: x_return_status := G_RET_STS_ERROR ;
3557:
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3561: END IF;
3562:
3563: IF l_translated_tmpl_revision_csr%ISOPEN THEN

Line 3560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3556: x_return_status := G_RET_STS_ERROR ;
3557:
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3560: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3561: END IF;
3562:
3563: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3564: CLOSE l_translated_tmpl_revision_csr;

Line 3570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3566:
3567: x_return_status := G_RET_STS_UNEXP_ERROR ;
3568:
3569: WHEN OTHERS THEN
3570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3571: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_revision because of EXCEPTION: '||sqlerrm);
3572: END IF;
3573:
3574: IF l_translated_tmpl_revision_csr%ISOPEN THEN

Line 3571: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_revision because of EXCEPTION: '||sqlerrm);

3567: x_return_status := G_RET_STS_UNEXP_ERROR ;
3568:
3569: WHEN OTHERS THEN
3570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3571: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_revision because of EXCEPTION: '||sqlerrm);
3572: END IF;
3573:
3574: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3575: CLOSE l_translated_tmpl_revision_csr;

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

3613:
3614:
3615: BEGIN
3616:
3617: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3618: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_effectivity');
3619: END IF;
3620: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_EFF,
3621: x_perform_qa => l_perform_trans_tmpl_eff_qa,

Line 3618: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_effectivity');

3614:
3615: BEGIN
3616:
3617: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3618: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_effectivity');
3619: END IF;
3620: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_EFF,
3621: x_perform_qa => l_perform_trans_tmpl_eff_qa,
3622: x_qa_name => l_desc,

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

3660: END IF;
3661:
3662: END IF;
3663:
3664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3666: END IF;
3667:
3668: EXCEPTION

Line 3665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');

3661:
3662: END IF;
3663:
3664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3666: END IF;
3667:
3668: EXCEPTION
3669: WHEN FND_API.G_EXC_ERROR THEN

Line 3670: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3666: END IF;
3667:
3668: EXCEPTION
3669: WHEN FND_API.G_EXC_ERROR THEN
3670: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3672: END IF;
3673:
3674: IF l_get_trans_tmpl_csr%ISOPEN THEN

Line 3671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');

3667:
3668: EXCEPTION
3669: WHEN FND_API.G_EXC_ERROR THEN
3670: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3672: END IF;
3673:
3674: IF l_get_trans_tmpl_csr%ISOPEN THEN
3675: CLOSE l_get_trans_tmpl_csr;

Line 3681: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3677:
3678: x_return_status := G_RET_STS_ERROR ;
3679:
3680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3681: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3683: END IF;
3684:
3685: IF l_get_trans_tmpl_csr%ISOPEN THEN

Line 3682: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3678: x_return_status := G_RET_STS_ERROR ;
3679:
3680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3681: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3683: END IF;
3684:
3685: IF l_get_trans_tmpl_csr%ISOPEN THEN
3686: CLOSE l_get_trans_tmpl_csr;

Line 3692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3688:
3689: x_return_status := G_RET_STS_UNEXP_ERROR ;
3690:
3691: WHEN OTHERS THEN
3692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_effectivity because of EXCEPTION: '||sqlerrm);
3694: END IF;
3695:
3696: IF l_get_trans_tmpl_csr%ISOPEN THEN

Line 3693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_effectivity because of EXCEPTION: '||sqlerrm);

3689: x_return_status := G_RET_STS_UNEXP_ERROR ;
3690:
3691: WHEN OTHERS THEN
3692: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3693: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_effectivity because of EXCEPTION: '||sqlerrm);
3694: END IF;
3695:
3696: IF l_get_trans_tmpl_csr%ISOPEN THEN
3697: CLOSE l_get_trans_tmpl_csr;

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

3723: l_perform_articles_exist_qa VARCHAR2(1);
3724:
3725: BEGIN
3726:
3727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3728: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_articles_exist');
3729: END IF;
3730:
3731: get_qa_code_detail(p_qa_code => G_CHECK_ART_EXT,

Line 3728: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_articles_exist');

3724:
3725: BEGIN
3726:
3727: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3728: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_articles_exist');
3729: END IF;
3730:
3731: get_qa_code_detail(p_qa_code => G_CHECK_ART_EXT,
3732: x_perform_qa => l_perform_articles_exist_qa,

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

3772: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3773: END IF;
3774:
3775:
3776: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3777: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3778: END IF;
3779:
3780: EXCEPTION

Line 3777: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');

3773: END IF;
3774:
3775:
3776: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3777: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3778: END IF;
3779:
3780: EXCEPTION
3781: WHEN FND_API.G_EXC_ERROR THEN

Line 3782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3778: END IF;
3779:
3780: EXCEPTION
3781: WHEN FND_API.G_EXC_ERROR THEN
3782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3783: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3784: END IF;
3785:
3786: x_return_status := G_RET_STS_ERROR ;

Line 3783: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');

3779:
3780: EXCEPTION
3781: WHEN FND_API.G_EXC_ERROR THEN
3782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3783: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3784: END IF;
3785:
3786: x_return_status := G_RET_STS_ERROR ;
3787:

Line 3789: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3785:
3786: x_return_status := G_RET_STS_ERROR ;
3787:
3788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3789: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3791: END IF;
3792:
3793: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 3790: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

3786: x_return_status := G_RET_STS_ERROR ;
3787:
3788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3789: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3791: END IF;
3792:
3793: x_return_status := G_RET_STS_UNEXP_ERROR ;
3794:

Line 3796: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3792:
3793: x_return_status := G_RET_STS_UNEXP_ERROR ;
3794:
3795: WHEN OTHERS THEN
3796: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3797: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_articles_exist because of EXCEPTION: '||sqlerrm);
3798: END IF;
3799:
3800: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 3797: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_articles_exist because of EXCEPTION: '||sqlerrm);

3793: x_return_status := G_RET_STS_UNEXP_ERROR ;
3794:
3795: WHEN OTHERS THEN
3796: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3797: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_articles_exist because of EXCEPTION: '||sqlerrm);
3798: END IF;
3799:
3800: x_return_status := G_RET_STS_UNEXP_ERROR ;
3801:

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

3917: END get_art_title_sec;
3918:
3919: BEGIN
3920:
3921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_validate_draft_articles');
3923: END IF;
3924:
3925: IF (p_doc_type <> 'TEMPLATE') THEN

Line 3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_validate_draft_articles');

3918:
3919: BEGIN
3920:
3921: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3922: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_validate_draft_articles');
3923: END IF;
3924:
3925: IF (p_doc_type <> 'TEMPLATE') THEN
3926: RETURN; -- no other doc type is supported.

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

4225: END LOOP;
4226: END IF;
4227:
4228:
4229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4231: END IF;
4232:
4233: EXCEPTION

Line 4230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');

4226: END IF;
4227:
4228:
4229: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4231: END IF;
4232:
4233: EXCEPTION
4234: WHEN FND_API.G_EXC_ERROR THEN

Line 4235: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4231: END IF;
4232:
4233: EXCEPTION
4234: WHEN FND_API.G_EXC_ERROR THEN
4235: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4236: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4237: END IF;
4238:
4239: IF l_draft_art_csr%ISOPEN THEN

Line 4236: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');

4232:
4233: EXCEPTION
4234: WHEN FND_API.G_EXC_ERROR THEN
4235: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4236: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4237: END IF;
4238:
4239: IF l_draft_art_csr%ISOPEN THEN
4240: CLOSE l_draft_art_csr;

Line 4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4242:
4243: x_return_status := G_RET_STS_ERROR ;
4244:
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4248: END IF;
4249:
4250: IF l_draft_art_csr%ISOPEN THEN

Line 4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

4243: x_return_status := G_RET_STS_ERROR ;
4244:
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4248: END IF;
4249:
4250: IF l_draft_art_csr%ISOPEN THEN
4251: CLOSE l_draft_art_csr;

Line 4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4253:
4254: x_return_status := G_RET_STS_UNEXP_ERROR ;
4255:
4256: WHEN OTHERS THEN
4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4258: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_validate_draft_articles because of EXCEPTION: '||sqlerrm);
4259: END IF;
4260:
4261: IF l_draft_art_csr%ISOPEN THEN

Line 4258: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_validate_draft_articles because of EXCEPTION: '||sqlerrm);

4254: x_return_status := G_RET_STS_UNEXP_ERROR ;
4255:
4256: WHEN OTHERS THEN
4257: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4258: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_validate_draft_articles because of EXCEPTION: '||sqlerrm);
4259: END IF;
4260:
4261: IF l_draft_art_csr%ISOPEN THEN
4262: CLOSE l_draft_art_csr;

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

4304: AND VER.article_status='REJECTED';
4305:
4306: BEGIN
4307:
4308: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_rejected_clauses');
4310: END IF;
4311:
4312: IF (p_doc_type <> 'TEMPLATE') THEN

Line 4309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_rejected_clauses');

4305:
4306: BEGIN
4307:
4308: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4309: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_rejected_clauses');
4310: END IF;
4311:
4312: IF (p_doc_type <> 'TEMPLATE') THEN
4313: RETURN; -- no other doc type is supported.

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

4352: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4353: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4354: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4355: END LOOP;
4356: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4358: END IF;
4359:
4360: EXCEPTION

Line 4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');

4353: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4354: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4355: END LOOP;
4356: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4358: END IF;
4359:
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN

Line 4362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4358: END IF;
4359:
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4364: END IF;
4365:
4366: IF l_rejected_art_csr%ISOPEN THEN

Line 4363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');

4359:
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4364: END IF;
4365:
4366: IF l_rejected_art_csr%ISOPEN THEN
4367: CLOSE l_rejected_art_csr;

Line 4373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4369:
4370: x_return_status := G_RET_STS_ERROR ;
4371:
4372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4375: END IF;
4376:
4377: IF l_rejected_art_csr%ISOPEN THEN

Line 4374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

4370: x_return_status := G_RET_STS_ERROR ;
4371:
4372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4375: END IF;
4376:
4377: IF l_rejected_art_csr%ISOPEN THEN
4378: CLOSE l_rejected_art_csr;

Line 4384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4380:
4381: x_return_status := G_RET_STS_UNEXP_ERROR ;
4382:
4383: WHEN OTHERS THEN
4384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_rejected_clauses because of EXCEPTION: '||sqlerrm);
4386: END IF;
4387:
4388: IF l_rejected_art_csr%ISOPEN THEN

Line 4385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_rejected_clauses because of EXCEPTION: '||sqlerrm);

4381: x_return_status := G_RET_STS_UNEXP_ERROR ;
4382:
4383: WHEN OTHERS THEN
4384: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4385: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_rejected_clauses because of EXCEPTION: '||sqlerrm);
4386: END IF;
4387:
4388: IF l_rejected_art_csr%ISOPEN THEN
4389: CLOSE l_rejected_art_csr;

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

4574: -- if p_qa_mode is null then p_qa_mode := G_NORMAL_QA; end if;
4575: -- if p_validation_level is null then p_validation_level := 'A'; end if;
4576: l_now := SYSDATE;
4577:
4578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4579: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Entered QA_Doc');
4580: END IF;
4581: -- Initialize API return status to success
4582: x_return_status := G_RET_STS_SUCCESS;

Line 4579: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Entered QA_Doc');

4575: -- if p_validation_level is null then p_validation_level := 'A'; end if;
4576: l_now := SYSDATE;
4577:
4578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4579: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Entered QA_Doc');
4580: END IF;
4581: -- Initialize API return status to success
4582: x_return_status := G_RET_STS_SUCCESS;
4583: x_qa_return_status := G_QA_STS_SUCCESS;

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

4584: g_validation_level := p_validation_level;
4585:
4586: IF p_doc_type = G_TMPL_DOC_TYPE THEN
4587:
4588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2110: Opening cursor l_get_effective_date_template');
4590: END IF;
4591: OPEN l_get_effective_date_template;
4592: --FETCH l_get_effective_date_template INTO l_start_date, l_end_date;

Line 4589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2110: Opening cursor l_get_effective_date_template');

4585:
4586: IF p_doc_type = G_TMPL_DOC_TYPE THEN
4587:
4588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2110: Opening cursor l_get_effective_date_template');
4590: END IF;
4591: OPEN l_get_effective_date_template;
4592: --FETCH l_get_effective_date_template INTO l_start_date, l_end_date;
4593: FETCH l_get_effective_date_template INTO g_start_date, g_end_date,

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

4608: END IF;
4609:
4610: ELSE
4611: -- doc type not Template
4612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2120: Opening cursor l_get_effective_date');
4614: END IF;
4615: OPEN l_get_effective_date;
4616: FETCH l_get_effective_date INTO l_article_effective_date;

Line 4613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2120: Opening cursor l_get_effective_date');

4609:
4610: ELSE
4611: -- doc type not Template
4612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2120: Opening cursor l_get_effective_date');
4614: END IF;
4615: OPEN l_get_effective_date;
4616: FETCH l_get_effective_date INTO l_article_effective_date;
4617: IF l_get_effective_date%NOTFOUND THEN

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

4632: l_xprt_article_tbl.DELETE;
4633: */
4634:
4635: -- Get all QA Detail
4636: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2130: Before FOR cr IN l_get_qa_detail_csr LOOP');
4638: END IF;
4639: q := 0;
4640: FOR cr IN l_get_qa_detail_csr LOOP

Line 4637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2130: Before FOR cr IN l_get_qa_detail_csr LOOP');

4633: */
4634:
4635: -- Get all QA Detail
4636: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2130: Before FOR cr IN l_get_qa_detail_csr LOOP');
4638: END IF;
4639: q := 0;
4640: FOR cr IN l_get_qa_detail_csr LOOP
4641:

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

4674:
4675:
4676: -- populate l_article_tbl with all the articles.
4677: IF p_doc_type <> G_TMPL_DOC_TYPE THEN
4678: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2140: Before FOR cr IN l_get_doc_articles_csr LOOP');
4680: END IF;
4681: i := 0;
4682: FOR cr IN l_get_doc_articles_csr LOOP

Line 4679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2140: Before FOR cr IN l_get_doc_articles_csr LOOP');

4675:
4676: -- populate l_article_tbl with all the articles.
4677: IF p_doc_type <> G_TMPL_DOC_TYPE THEN
4678: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2140: Before FOR cr IN l_get_doc_articles_csr LOOP');
4680: END IF;
4681: i := 0;
4682: FOR cr IN l_get_doc_articles_csr LOOP
4683: i := i+1;

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

4693: ELSE
4694: -- doc type is TEMPLATE, if expert enabled get the expert clauses
4695: /* expert commented out
4696: IF (g_expert_enabled = 'Y') then
4697: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4698: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2150: Before OPEN l_get_xprt_articles_csr');
4699: END IF;
4700: OPEN l_get_xprt_articles_csr;
4701: FETCH l_get_xprt_articles_csr BULK COLLECT INTO l_xprt_article_tbl;

Line 4698: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2150: Before OPEN l_get_xprt_articles_csr');

4694: -- doc type is TEMPLATE, if expert enabled get the expert clauses
4695: /* expert commented out
4696: IF (g_expert_enabled = 'Y') then
4697: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4698: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2150: Before OPEN l_get_xprt_articles_csr');
4699: END IF;
4700: OPEN l_get_xprt_articles_csr;
4701: FETCH l_get_xprt_articles_csr BULK COLLECT INTO l_xprt_article_tbl;
4702: CLOSE l_get_xprt_articles_csr;

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

4702: CLOSE l_get_xprt_articles_csr;
4703: END IF;
4704: */
4705:
4706: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4707: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2160: Before FOR cr IN l_get_tmpl_articles_csr');
4708: END IF;
4709: i := 0;
4710: FOR cr IN l_get_tmpl_articles_csr LOOP

Line 4707: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2160: Before FOR cr IN l_get_tmpl_articles_csr');

4703: END IF;
4704: */
4705:
4706: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4707: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2160: Before FOR cr IN l_get_tmpl_articles_csr');
4708: END IF;
4709: i := 0;
4710: FOR cr IN l_get_tmpl_articles_csr LOOP
4711: i := i+1;

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

4720: END LOOP;
4721: END IF;
4722:
4723: -- populate l_section_tbl with all the sections.
4724: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2170: Before FOR cr IN l_get_sections_csr LOOP');
4726: END IF;
4727: i := 0;
4728: FOR cr IN l_get_sections_csr LOOP

Line 4725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2170: Before FOR cr IN l_get_sections_csr LOOP');

4721: END IF;
4722:
4723: -- populate l_section_tbl with all the sections.
4724: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2170: Before FOR cr IN l_get_sections_csr LOOP');
4726: END IF;
4727: i := 0;
4728: FOR cr IN l_get_sections_csr LOOP
4729: i := i+1;

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

4742: ------------------------------------------------------------
4743: -- QA Check for Layout Template to be run for templates ONLY
4744: ------------------------------------------------------------
4745: IF p_doc_type=G_TMPL_DOC_TYPE THEN
4746: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4747: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2180: calling check_layout_template');
4748: END IF;
4749: check_layout_template(
4750: p_doc_type => p_doc_type,

Line 4747: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2180: calling check_layout_template');

4743: -- QA Check for Layout Template to be run for templates ONLY
4744: ------------------------------------------------------------
4745: IF p_doc_type=G_TMPL_DOC_TYPE THEN
4746: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4747: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2180: calling check_layout_template');
4748: END IF;
4749: check_layout_template(
4750: p_doc_type => p_doc_type,
4751: p_doc_id => p_doc_id,

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

4758: RAISE FND_API.G_EXC_ERROR ;
4759: END IF;
4760:
4761: --call new internal procedure to check for article existence
4762: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4763: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2190: calling check_articles_exist');
4764: END IF;
4765: check_articles_exist (
4766: p_doc_type => p_doc_type,

Line 4763: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2190: calling check_articles_exist');

4759: END IF;
4760:
4761: --call new internal procedure to check for article existence
4762: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4763: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2190: calling check_articles_exist');
4764: END IF;
4765: check_articles_exist (
4766: p_doc_type => p_doc_type,
4767: p_doc_id => p_doc_id,

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

4774: RAISE FND_API.G_EXC_ERROR ;
4775: END IF;
4776:
4777: --call new internal procedure to validate any draft articles
4778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4779: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_validate_draft_articles');
4780: END IF;
4781: check_validate_draft_articles(
4782: p_doc_type => p_doc_type,

Line 4779: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_validate_draft_articles');

4775: END IF;
4776:
4777: --call new internal procedure to validate any draft articles
4778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4779: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_validate_draft_articles');
4780: END IF;
4781: check_validate_draft_articles(
4782: p_doc_type => p_doc_type,
4783: p_doc_id => p_doc_id,

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

4791: END IF;
4792:
4793: -- For Bug# 6979012
4794: --call new internal procedure to give a warning for rejected articles
4795: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_rejected_clauses');
4797: END IF;
4798: check_rejected_clauses(
4799: p_doc_type => p_doc_type,

Line 4796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_rejected_clauses');

4792:
4793: -- For Bug# 6979012
4794: --call new internal procedure to give a warning for rejected articles
4795: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4796: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_rejected_clauses');
4797: END IF;
4798: check_rejected_clauses(
4799: p_doc_type => p_doc_type,
4800: p_doc_id => p_doc_id,

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

4808: END IF;
4809: -- Changes for Bug# 6979012 Ends
4810:
4811: --MLS for templates
4812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2202: calling Check_translated_tmpl_revision');
4814: END IF;
4815: Check_translated_tmpl_rev(
4816: p_doc_type => p_doc_type,

Line 4813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2202: calling Check_translated_tmpl_revision');

4809: -- Changes for Bug# 6979012 Ends
4810:
4811: --MLS for templates
4812: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4813: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2202: calling Check_translated_tmpl_revision');
4814: END IF;
4815: Check_translated_tmpl_rev(
4816: p_doc_type => p_doc_type,
4817: p_doc_id => p_doc_id,

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

4823: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4824: RAISE FND_API.G_EXC_ERROR ;
4825: END IF;
4826:
4827: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');
4829: END IF;
4830: Check_translated_tmpl_eff(
4831: p_doc_type => p_doc_type,

Line 4828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');

4824: RAISE FND_API.G_EXC_ERROR ;
4825: END IF;
4826:
4827: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');
4829: END IF;
4830: Check_translated_tmpl_eff(
4831: p_doc_type => p_doc_type,
4832: p_doc_id => p_doc_id,

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

4846:
4847: --------------------------------------------
4848: -- QA Check for Incompatible articles
4849: --------------------------------------------
4850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2210: calling check_validate_draft_articles');
4852: END IF;
4853: Check_Incomp_and_alternate(
4854: p_qa_mode => p_qa_mode,

Line 4851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2210: calling check_validate_draft_articles');

4847: --------------------------------------------
4848: -- QA Check for Incompatible articles
4849: --------------------------------------------
4850: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4851: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2210: calling check_validate_draft_articles');
4852: END IF;
4853: Check_Incomp_and_alternate(
4854: p_qa_mode => p_qa_mode,
4855: p_doc_type => p_doc_type,

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

4865:
4866: --------------------------------------------
4867: -- QA Check for Duplicate articles
4868: --------------------------------------------
4869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2220: calling Check_duplicate_articles');
4871: END IF;
4872: Check_duplicate_articles(
4873: p_qa_mode => p_qa_mode,

Line 4870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2220: calling Check_duplicate_articles');

4866: --------------------------------------------
4867: -- QA Check for Duplicate articles
4868: --------------------------------------------
4869: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4870: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2220: calling Check_duplicate_articles');
4871: END IF;
4872: Check_duplicate_articles(
4873: p_qa_mode => p_qa_mode,
4874: p_doc_type => p_doc_type,

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

4884:
4885: --------------------------------------------
4886: -- QA Check for variable-doc type usage
4887: --------------------------------------------
4888: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4889: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2230: calling Check_var_doc_type_usage');
4890: END IF;
4891: Check_var_doc_type_usage(
4892: p_qa_mode => p_qa_mode,

Line 4889: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2230: calling Check_var_doc_type_usage');

4885: --------------------------------------------
4886: -- QA Check for variable-doc type usage
4887: --------------------------------------------
4888: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4889: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2230: calling Check_var_doc_type_usage');
4890: END IF;
4891: Check_var_doc_type_usage(
4892: p_qa_mode => p_qa_mode,
4893: p_doc_type => p_doc_type,

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

4903:
4904: ----------------------------------------------------------------
4905: -- QA Check for article effectivity and old version of article
4906: ----------------------------------------------------------------
4907: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4908: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2240: calling Check_art_effectivity');
4909: END IF;
4910: Check_art_effectivity(
4911: p_qa_mode => p_qa_mode,

Line 4908: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2240: calling Check_art_effectivity');

4904: ----------------------------------------------------------------
4905: -- QA Check for article effectivity and old version of article
4906: ----------------------------------------------------------------
4907: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4908: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2240: calling Check_art_effectivity');
4909: END IF;
4910: Check_art_effectivity(
4911: p_qa_mode => p_qa_mode,
4912: p_doc_type => p_doc_type,

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

4928:
4929: --------------------------------------------
4930: -- QA Check for User Variables
4931: --------------------------------------------
4932: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4933: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2250: calling Check_variables');
4934: END IF;
4935: Check_variables(
4936: p_doc_type => p_doc_type,

Line 4933: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2250: calling Check_variables');

4929: --------------------------------------------
4930: -- QA Check for User Variables
4931: --------------------------------------------
4932: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4933: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2250: calling Check_variables');
4934: END IF;
4935: Check_variables(
4936: p_doc_type => p_doc_type,
4937: p_doc_id => p_doc_id,

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

4946:
4947: ---------------------------------------------------------
4948: -- QA Check for unassigned articles
4949: ---------------------------------------------------------
4950: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2260: calling Check_unassigned_articles');
4952: END IF;
4953: Check_unassigned_articles(
4954: p_doc_type => p_doc_type,

Line 4951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2260: calling Check_unassigned_articles');

4947: ---------------------------------------------------------
4948: -- QA Check for unassigned articles
4949: ---------------------------------------------------------
4950: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2260: calling Check_unassigned_articles');
4952: END IF;
4953: Check_unassigned_articles(
4954: p_doc_type => p_doc_type,
4955: p_doc_id => p_doc_id,

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

4964:
4965: ---------------------------------------------------------------
4966: -- QA Check for empty sections
4967: ---------------------------------------------------------------
4968: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2270: calling Check_empty_sections');
4970: END IF;
4971: Check_empty_sections(
4972: p_doc_type => p_doc_type,

Line 4969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2270: calling Check_empty_sections');

4965: ---------------------------------------------------------------
4966: -- QA Check for empty sections
4967: ---------------------------------------------------------------
4968: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2270: calling Check_empty_sections');
4970: END IF;
4971: Check_empty_sections(
4972: p_doc_type => p_doc_type,
4973: p_doc_id => p_doc_id,

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

4982:
4983: ---------------------------------------------------------------
4984: -- QA Check for inactive template
4985: ---------------------------------------------------------------
4986: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4987: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2280: calling check_inactive_template');
4988: END IF;
4989: check_inactive_template(
4990: p_doc_type => p_doc_type,

Line 4987: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2280: calling check_inactive_template');

4983: ---------------------------------------------------------------
4984: -- QA Check for inactive template
4985: ---------------------------------------------------------------
4986: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4987: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2280: calling check_inactive_template');
4988: END IF;
4989: check_inactive_template(
4990: p_doc_type => p_doc_type,
4991: p_doc_id => p_doc_id,

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

5002:
5003: ------------------------------------------------------------
5004: -- QA Check for Amended article with no description
5005: ------------------------------------------------------------
5006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2290: calling Check_article_Amend_No_Texts');
5008: END IF;
5009: Check_article_Amend_No_Texts(
5010: p_doc_type => p_doc_type,

Line 5007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2290: calling Check_article_Amend_No_Texts');

5003: ------------------------------------------------------------
5004: -- QA Check for Amended article with no description
5005: ------------------------------------------------------------
5006: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5007: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2290: calling Check_article_Amend_No_Texts');
5008: END IF;
5009: Check_article_Amend_No_Texts(
5010: p_doc_type => p_doc_type,
5011: p_doc_id => p_doc_id,

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

5020:
5021: ------------------------------------------------------------
5022: -- QA Check for Amended section with no description
5023: ------------------------------------------------------------
5024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: calling Check_Section_Amend_No_Texts');
5026: END IF;
5027: Check_Section_Amend_No_Texts(
5028: p_doc_type => p_doc_type,

Line 5025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: calling Check_Section_Amend_No_Texts');

5021: ------------------------------------------------------------
5022: -- QA Check for Amended section with no description
5023: ------------------------------------------------------------
5024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: calling Check_Section_Amend_No_Texts');
5026: END IF;
5027: Check_Section_Amend_No_Texts(
5028: p_doc_type => p_doc_type,
5029: p_doc_id => p_doc_id,

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

5042:
5043: ------------------------------------------------------------
5044: -- QA Check for expert
5045: ------------------------------------------------------------
5046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2310: calling OKC_EXPRT_UTIL_GRP.contract_expert_bv');
5048: END IF;
5049:
5050: IF p_doc_type = G_TMPL_DOC_TYPE THEN

Line 5047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2310: calling OKC_EXPRT_UTIL_GRP.contract_expert_bv');

5043: ------------------------------------------------------------
5044: -- QA Check for expert
5045: ------------------------------------------------------------
5046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2310: calling OKC_EXPRT_UTIL_GRP.contract_expert_bv');
5048: END IF;
5049:
5050: IF p_doc_type = G_TMPL_DOC_TYPE THEN
5051: --Added 11.5.10+ CE

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

5089:
5090: -- update common attributes for the QA table
5091: IF x_qa_result_tbl.COUNT > 0 THEN
5092:
5093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2320: before FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP');
5095: END IF;
5096:
5097: FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP

Line 5094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2320: before FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP');

5090: -- update common attributes for the QA table
5091: IF x_qa_result_tbl.COUNT > 0 THEN
5092:
5093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2320: before FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP');
5095: END IF;
5096:
5097: FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP
5098: x_qa_result_tbl(i).document_type := p_doc_type;

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

5104: END IF;
5105: IF x_qa_result_tbl(i).Error_severity = G_QA_STS_WARNING THEN
5106: l_warning_found := true;
5107: END IF;
5108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', article_id:'||x_qa_result_tbl(i).article_id||', title:'||x_qa_result_tbl(i).title||', qa_code:'||x_qa_result_tbl(i).qa_code);
5110: END IF;
5111:
5112: END LOOP;

Line 5109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', article_id:'||x_qa_result_tbl(i).article_id||', title:'||x_qa_result_tbl(i).title||', qa_code:'||x_qa_result_tbl(i).qa_code);

5105: IF x_qa_result_tbl(i).Error_severity = G_QA_STS_WARNING THEN
5106: l_warning_found := true;
5107: END IF;
5108: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', article_id:'||x_qa_result_tbl(i).article_id||', title:'||x_qa_result_tbl(i).title||', qa_code:'||x_qa_result_tbl(i).qa_code);
5110: END IF;
5111:
5112: END LOOP;
5113: IF l_error_found THEN

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

5119:
5120:
5121: END IF; -- IF l_perform_QA then
5122:
5123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5125: END IF;
5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5127:

Line 5124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');

5120:
5121: END IF; -- IF l_perform_QA then
5122:
5123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5125: END IF;
5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5127:
5128: EXCEPTION

Line 5130: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5127:
5128: EXCEPTION
5129: WHEN FND_API.G_EXC_ERROR THEN
5130: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5131: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5132: END IF;
5133:
5134: IF l_get_qa_detail_csr%ISOPEN THEN

Line 5131: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');

5127:
5128: EXCEPTION
5129: WHEN FND_API.G_EXC_ERROR THEN
5130: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5131: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5132: END IF;
5133:
5134: IF l_get_qa_detail_csr%ISOPEN THEN
5135: CLOSE l_get_qa_detail_csr;

Line 5161: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: ROLLBACK TO g_QA_Doc;
5161: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5162: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5163: END IF;
5164: IF l_get_qa_detail_csr%ISOPEN THEN
5165: CLOSE l_get_qa_detail_csr;

Line 5162: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: ROLLBACK TO g_QA_Doc;
5161: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5162: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5163: END IF;
5164: IF l_get_qa_detail_csr%ISOPEN THEN
5165: CLOSE l_get_qa_detail_csr;
5166: END IF;

Line 5190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5186: x_return_status := G_RET_STS_UNEXP_ERROR ;
5187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5188:
5189: WHEN OTHERS THEN
5190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5191: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
5192: END IF;
5193:
5194: IF l_get_qa_detail_csr%ISOPEN THEN

Line 5191: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);

5187: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5188:
5189: WHEN OTHERS THEN
5190: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5191: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
5192: END IF;
5193:
5194: IF l_get_qa_detail_csr%ISOPEN THEN
5195: CLOSE l_get_qa_detail_csr;