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

1148: and adminppl.effective_start_date = adminppl.start_date;
1149:
1150: BEGIN
1151:
1152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1154: END IF;
1155:
1156: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1149:
1150: BEGIN
1151:
1152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1154: END IF;
1155:
1156: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);

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

1152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1154: END IF;
1155:
1156: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);
1158:
1159: END IF;
1160:

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

1153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_contract_admin');
1154: END IF;
1155:
1156: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_ctrt_admin : '||l_ctrt_admin);
1158:
1159: END IF;
1160:
1161: -- Initialize API return status to success

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

1278: END IF; -- IF (l_ctrt_admin = 'Y')
1279:
1280: END IF;-- IF l_perform_ctrt_admin_qa ='Y'
1281:
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1284: END IF;
1285:
1286: EXCEPTION

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

1279:
1280: END IF;-- IF l_perform_ctrt_admin_qa ='Y'
1281:
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1284: END IF;
1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN

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

1284: END IF;
1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1289: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1290: END IF;
1291:
1292: x_return_status := G_RET_STS_ERROR ;

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

1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1289: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1290: END IF;
1291:
1292: x_return_status := G_RET_STS_ERROR ;
1293:

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

1291:
1292: x_return_status := G_RET_STS_ERROR ;
1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: 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');
1297: END IF;
1298:
1299: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1296: 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');

1292: x_return_status := G_RET_STS_ERROR ;
1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: 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');
1297: END IF;
1298:
1299: x_return_status := G_RET_STS_UNEXP_ERROR ;
1300:

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

1298:
1299: x_return_status := G_RET_STS_UNEXP_ERROR ;
1300:
1301: WHEN OTHERS THEN
1302: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1303: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1304: END IF;
1305:
1306: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1299: x_return_status := G_RET_STS_UNEXP_ERROR ;
1300:
1301: WHEN OTHERS THEN
1302: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1303: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Incomp_and_alternate because of EXCEPTION: '||sqlerrm);
1304: END IF;
1305:
1306: x_return_status := G_RET_STS_UNEXP_ERROR ;
1307:

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

1347: */
1348:
1349: BEGIN
1350:
1351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_duplicate_articles');
1353: END IF;
1354:
1355: get_qa_code_detail(p_qa_code => 'CHECK_DUPLICATE',

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

1348:
1349: BEGIN
1350:
1351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_duplicate_articles');
1353: END IF;
1354:
1355: get_qa_code_detail(p_qa_code => 'CHECK_DUPLICATE',
1356: x_perform_qa => l_perform_duplicate_qa,

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

1371: END IF;
1372:
1373: IF l_article_tbl.COUNT > 0 THEN
1374:
1375: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: totally:'||l_article_tbl.COUNT||' articles to check');
1377: END IF;
1378:
1379: FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP

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

1372:
1373: IF l_article_tbl.COUNT > 0 THEN
1374:
1375: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: totally:'||l_article_tbl.COUNT||' articles to check');
1377: END IF;
1378:
1379: FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1380:

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

1386:
1387: --Bug 4128923 l_error_count := 0;
1388:
1389: FOR k IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1390: --IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: -- FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', k:'||k);
1392: --END IF;
1393:
1394: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

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

1387: --Bug 4128923 l_error_count := 0;
1388:
1389: FOR k IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
1390: --IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1391: -- FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: i:'||i||', k:'||k);
1392: --END IF;
1393:
1394: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
1395: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)

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

1394: IF nvl(l_article_tbl(k).amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
1395: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)
1396: =Nvl(l_article_tbl(i).std_art_id,l_article_tbl(i).article_id) THEN
1397:
1398: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Dupicate found - i:'||i||', k:'||k);
1400: END IF;
1401: l_error_count := l_error_count + 1;
1402: END IF;

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

1395: AND Nvl(l_article_tbl(k).std_art_id,l_article_tbl(k).article_id)
1396: =Nvl(l_article_tbl(i).std_art_id,l_article_tbl(i).article_id) THEN
1397:
1398: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Dupicate found - i:'||i||', k:'||k);
1400: END IF;
1401: l_error_count := l_error_count + 1;
1402: END IF;
1403: END LOOP; -- FOR k IN l_article_tbl1.FIRST..l_article_tbl1.LAST LOOP

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

1455: END IF; -- IF l_article_tbl.COUNT > 0 THEN
1456:
1457: END IF; -- IF l_perform_duplicate_qa ='Y' THEN
1458:
1459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1461: END IF;
1462:
1463: EXCEPTION

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

1456:
1457: END IF; -- IF l_perform_duplicate_qa ='Y' THEN
1458:
1459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1461: END IF;
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN

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

1461: END IF;
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1467: END IF;
1468:
1469: /* expert commented out

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

1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1467: END IF;
1468:
1469: /* expert commented out
1470: IF l_get_dup_xprt_csr%ISOPEN THEN

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

1474:
1475: x_return_status := G_RET_STS_ERROR ;
1476:
1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1478: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1480: END IF;
1481:
1482: /* expert commented out

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

1475: x_return_status := G_RET_STS_ERROR ;
1476:
1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1478: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1480: END IF;
1481:
1482: /* expert commented out
1483: IF l_get_dup_xprt_csr%ISOPEN THEN

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

1486: */
1487: x_return_status := G_RET_STS_UNEXP_ERROR ;
1488:
1489: WHEN OTHERS THEN
1490: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_duplicate_articles because of EXCEPTION: '||sqlerrm);
1492: END IF;
1493:
1494: /* expert commented out

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

1487: x_return_status := G_RET_STS_UNEXP_ERROR ;
1488:
1489: WHEN OTHERS THEN
1490: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_duplicate_articles because of EXCEPTION: '||sqlerrm);
1492: END IF;
1493:
1494: /* expert commented out
1495: IF l_get_dup_xprt_csr%ISOPEN THEN

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

1714: */
1715:
1716: BEGIN
1717:
1718: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_var_doc_type_usage');
1720: END IF;
1721:
1722: get_qa_code_detail(p_qa_code => G_CHECK_VAR_USAGE,

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

1715:
1716: BEGIN
1717:
1718: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1719: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_var_doc_type_usage');
1720: END IF;
1721:
1722: get_qa_code_detail(p_qa_code => G_CHECK_VAR_USAGE,
1723: x_perform_qa => l_perform_var_usg_qa,

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

1807:
1808: END IF; -- IF l_perform_var_usg_qa ='Y' THEN
1809:
1810:
1811: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1812: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1813: END IF;
1814:
1815: EXCEPTION

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

1808: END IF; -- IF l_perform_var_usg_qa ='Y' THEN
1809:
1810:
1811: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1812: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1813: END IF;
1814:
1815: EXCEPTION
1816: WHEN FND_API.G_EXC_ERROR THEN

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

1813: END IF;
1814:
1815: EXCEPTION
1816: WHEN FND_API.G_EXC_ERROR THEN
1817: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1818: 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');
1819: END IF;
1820:
1821: IF l_check_usage_csr%ISOPEN THEN

Line 1818: 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');

1814:
1815: EXCEPTION
1816: WHEN FND_API.G_EXC_ERROR THEN
1817: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1818: 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');
1819: END IF;
1820:
1821: IF l_check_usage_csr%ISOPEN THEN
1822: CLOSE l_check_usage_csr ;

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

1830:
1831: x_return_status := G_RET_STS_ERROR ;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: 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');
1836: END IF;
1837:
1838: IF l_check_usage_csr%ISOPEN THEN

Line 1835: 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');

1831: x_return_status := G_RET_STS_ERROR ;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: 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');
1836: END IF;
1837:
1838: IF l_check_usage_csr%ISOPEN THEN
1839: CLOSE l_check_usage_csr ;

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

1847:
1848: x_return_status := G_RET_STS_UNEXP_ERROR ;
1849:
1850: WHEN OTHERS THEN
1851: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1852: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_var_doc_type_usage because of EXCEPTION: '||sqlerrm);
1853: END IF;
1854:
1855: IF l_check_usage_csr%ISOPEN THEN

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

1848: x_return_status := G_RET_STS_UNEXP_ERROR ;
1849:
1850: WHEN OTHERS THEN
1851: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1852: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_var_doc_type_usage because of EXCEPTION: '||sqlerrm);
1853: END IF;
1854:
1855: IF l_check_usage_csr%ISOPEN THEN
1856: CLOSE l_check_usage_csr ;

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

1910: ORDER BY VB.variable_code;
1911:
1912:
1913: BEGIN
1914: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1915: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_user_vars_with_procs');
1916: END IF;
1917:
1918: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,

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

1911:
1912:
1913: BEGIN
1914: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1915: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: Entered check_user_vars_with_procs');
1916: END IF;
1917:
1918: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,
1919: x_perform_qa => l_perform_int_qa,

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

1971:
1972: END LOOP;
1973:
1974:
1975: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1976: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1977: END IF;
1978:
1979: EXCEPTION

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

1972: END LOOP;
1973:
1974:
1975: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1976: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1977: END IF;
1978:
1979: EXCEPTION
1980: WHEN FND_API.G_EXC_ERROR THEN

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

1977: END IF;
1978:
1979: EXCEPTION
1980: WHEN FND_API.G_EXC_ERROR THEN
1981: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1982: 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');
1983: END IF;
1984:
1985: IF csr_get_udv_with_procs%ISOPEN THEN

Line 1982: 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');

1978:
1979: EXCEPTION
1980: WHEN FND_API.G_EXC_ERROR THEN
1981: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1982: 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');
1983: END IF;
1984:
1985: IF csr_get_udv_with_procs%ISOPEN THEN
1986: CLOSE csr_get_udv_with_procs;

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

1988:
1989: x_return_status := G_RET_STS_ERROR ;
1990:
1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: 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');
1994: END IF;
1995:
1996: IF csr_get_udv_with_procs%ISOPEN THEN

Line 1993: 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');

1989: x_return_status := G_RET_STS_ERROR ;
1990:
1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: 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');
1994: END IF;
1995:
1996: IF csr_get_udv_with_procs%ISOPEN THEN
1997: CLOSE csr_get_udv_with_procs;

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

1999:
2000: x_return_status := G_RET_STS_UNEXP_ERROR ;
2001:
2002: WHEN OTHERS THEN
2003: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving check_user_vars_with_procs because of EXCEPTION: '||sqlerrm);
2005: END IF;
2006:
2007: IF csr_get_udv_with_procs%ISOPEN THEN

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

2000: x_return_status := G_RET_STS_UNEXP_ERROR ;
2001:
2002: WHEN OTHERS THEN
2003: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2004: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving check_user_vars_with_procs because of EXCEPTION: '||sqlerrm);
2005: END IF;
2006:
2007: IF csr_get_udv_with_procs%ISOPEN THEN
2008: CLOSE csr_get_udv_with_procs;

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

2072:
2073:
2074: BEGIN
2075:
2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_variables');
2078: END IF;
2079:
2080: get_qa_code_detail(p_qa_code => G_CHECK_UNRESOLVED_SYS_VAR,

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

2073:
2074: BEGIN
2075:
2076: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_variables');
2078: END IF;
2079:
2080: get_qa_code_detail(p_qa_code => G_CHECK_UNRESOLVED_SYS_VAR,
2081: x_perform_qa => l_perform_sys_qa ,

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

2219:
2220: END IF; -- IF l_perform_int_QA='Y' or l_perform_ext_qa='Y' or l_perf
2221:
2222:
2223: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2224: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2225: END IF;
2226:
2227: EXCEPTION

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

2220: END IF; -- IF l_perform_int_QA='Y' or l_perform_ext_qa='Y' or l_perf
2221:
2222:
2223: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2224: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2225: END IF;
2226:
2227: EXCEPTION
2228: WHEN FND_API.G_EXC_ERROR THEN

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

2225: END IF;
2226:
2227: EXCEPTION
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2231: END IF;
2232:
2233: IF l_check_variable_csr%ISOPEN THEN

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

2226:
2227: EXCEPTION
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2231: END IF;
2232:
2233: IF l_check_variable_csr%ISOPEN THEN
2234: CLOSE l_check_variable_csr;

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

2236:
2237: x_return_status := G_RET_STS_ERROR ;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2241: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2242: END IF;
2243:
2244: IF l_check_variable_csr%ISOPEN THEN

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

2237: x_return_status := G_RET_STS_ERROR ;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2241: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2242: END IF;
2243:
2244: IF l_check_variable_csr%ISOPEN THEN
2245: CLOSE l_check_variable_csr;

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

2247:
2248: x_return_status := G_RET_STS_UNEXP_ERROR ;
2249:
2250: WHEN OTHERS THEN
2251: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_variables because of EXCEPTION: '||sqlerrm);
2253: END IF;
2254:
2255: IF l_check_variable_csr%ISOPEN THEN

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

2248: x_return_status := G_RET_STS_UNEXP_ERROR ;
2249:
2250: WHEN OTHERS THEN
2251: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_variables because of EXCEPTION: '||sqlerrm);
2253: END IF;
2254:
2255: IF l_check_variable_csr%ISOPEN THEN
2256: CLOSE l_check_variable_csr;

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

2292: AND nvl(kart.summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED;
2293:
2294: BEGIN
2295:
2296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_unassigned_articles');
2298: END IF;
2299:
2300: get_qa_code_detail(p_qa_code => G_CHECK_UNASSIGNED_ART,

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

2293:
2294: BEGIN
2295:
2296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_unassigned_articles');
2298: END IF;
2299:
2300: get_qa_code_detail(p_qa_code => G_CHECK_UNASSIGNED_ART,
2301: x_perform_qa => l_perform_unas_art_qa,

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

2328:
2329: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2330: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2331:
2332: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2334: END IF;
2335:
2336: EXCEPTION

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

2329: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2330: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2331:
2332: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2333: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2334: END IF;
2335:
2336: EXCEPTION
2337: WHEN FND_API.G_EXC_ERROR THEN

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

2334: END IF;
2335:
2336: EXCEPTION
2337: WHEN FND_API.G_EXC_ERROR THEN
2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2340: END IF;
2341:
2342: IF l_get_unass_art_crs%ISOPEN THEN

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

2335:
2336: EXCEPTION
2337: WHEN FND_API.G_EXC_ERROR THEN
2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2340: END IF;
2341:
2342: IF l_get_unass_art_crs%ISOPEN THEN
2343: CLOSE l_get_unass_art_crs;

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

2345:
2346: x_return_status := G_RET_STS_ERROR ;
2347:
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2349: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2351: END IF;
2352:
2353: IF l_get_unass_art_crs%ISOPEN THEN

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

2346: x_return_status := G_RET_STS_ERROR ;
2347:
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2349: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2351: END IF;
2352:
2353: IF l_get_unass_art_crs%ISOPEN THEN
2354: CLOSE l_get_unass_art_crs;

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

2356:
2357: x_return_status := G_RET_STS_UNEXP_ERROR ;
2358:
2359: WHEN OTHERS THEN
2360: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2361: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_unassigned_articles because of EXCEPTION: '||sqlerrm);
2362: END IF;
2363:
2364: IF l_get_unass_art_crs%ISOPEN THEN

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

2357: x_return_status := G_RET_STS_UNEXP_ERROR ;
2358:
2359: WHEN OTHERS THEN
2360: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2361: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_unassigned_articles because of EXCEPTION: '||sqlerrm);
2362: END IF;
2363:
2364: IF l_get_unass_art_crs%ISOPEN THEN
2365: CLOSE l_get_unass_art_crs;

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

2402: AND nvl(summary_amend_operation_code,'?') <> G_AMEND_CODE_DELETED);
2403: -- if section has sub sections then it is not considered empty Bug 3219528
2404: BEGIN
2405:
2406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2407: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_empty_sections');
2408: END IF;
2409:
2410: get_qa_code_detail(p_qa_code => G_CHECK_EMPTY_SECTION,

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

2403: -- if section has sub sections then it is not considered empty Bug 3219528
2404: BEGIN
2405:
2406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2407: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_empty_sections');
2408: END IF;
2409:
2410: get_qa_code_detail(p_qa_code => G_CHECK_EMPTY_SECTION,
2411: x_perform_qa => l_perform_empty_scn_qa,

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

2438:
2439: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2440: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2443: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2444: END IF;
2445:
2446: EXCEPTION

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

2439: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2440: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2441:
2442: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2443: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2444: END IF;
2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN

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

2444: END IF;
2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2450: END IF;
2451:
2452: IF l_get_empty_section_csr%ISOPEN THEN

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

2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2450: END IF;
2451:
2452: IF l_get_empty_section_csr%ISOPEN THEN
2453: CLOSE l_get_empty_section_csr;

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

2455:
2456: x_return_status := G_RET_STS_ERROR ;
2457:
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2461: END IF;
2462:
2463: IF l_get_empty_section_csr%ISOPEN THEN

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

2456: x_return_status := G_RET_STS_ERROR ;
2457:
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2461: END IF;
2462:
2463: IF l_get_empty_section_csr%ISOPEN THEN
2464: CLOSE l_get_empty_section_csr;

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

2466:
2467: x_return_status := G_RET_STS_UNEXP_ERROR ;
2468:
2469: WHEN OTHERS THEN
2470: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2471: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_empty_sections because of EXCEPTION: '||sqlerrm);
2472: END IF;
2473:
2474: IF l_get_empty_section_csr%ISOPEN THEN

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

2467: x_return_status := G_RET_STS_UNEXP_ERROR ;
2468:
2469: WHEN OTHERS THEN
2470: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2471: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_empty_sections because of EXCEPTION: '||sqlerrm);
2472: END IF;
2473:
2474: IF l_get_empty_section_csr%ISOPEN THEN
2475: CLOSE l_get_empty_section_csr;

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

2501: WHERE document_type = p_doc_type;
2502:
2503: BEGIN
2504:
2505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Section_Amend_No_Texts');
2507: END IF;
2508:
2509: --Bug 3681462 Check for disable_amend_yn

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

2502:
2503: BEGIN
2504:
2505: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2506: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_Section_Amend_No_Texts');
2507: END IF;
2508:
2509: --Bug 3681462 Check for disable_amend_yn
2510: OPEN l_get_doc_disable_amend_csr;

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

2551: END IF; -- IF l_perform_scn_amend_qa='Y' THEN
2552:
2553: END IF; -- l_disable_amend_yn = 'N'
2554:
2555: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2557: END IF;
2558:
2559: EXCEPTION

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

2552:
2553: END IF; -- l_disable_amend_yn = 'N'
2554:
2555: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2557: END IF;
2558:
2559: EXCEPTION
2560: WHEN FND_API.G_EXC_ERROR THEN

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

2557: END IF;
2558:
2559: EXCEPTION
2560: WHEN FND_API.G_EXC_ERROR THEN
2561: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: 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');
2563: END IF;
2564:
2565: x_return_status := G_RET_STS_ERROR ;

Line 2562: 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');

2558:
2559: EXCEPTION
2560: WHEN FND_API.G_EXC_ERROR THEN
2561: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: 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');
2563: END IF;
2564:
2565: x_return_status := G_RET_STS_ERROR ;
2566:

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

2564:
2565: x_return_status := G_RET_STS_ERROR ;
2566:
2567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2568: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: 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');
2570: END IF;
2571:
2572: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2569: 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');

2565: x_return_status := G_RET_STS_ERROR ;
2566:
2567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2568: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: 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');
2570: END IF;
2571:
2572: x_return_status := G_RET_STS_UNEXP_ERROR ;
2573:

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

2571:
2572: x_return_status := G_RET_STS_UNEXP_ERROR ;
2573:
2574: WHEN OTHERS THEN
2575: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2576: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Section_Amend_No_Texts because of EXCEPTION: '||sqlerrm);
2577: END IF;
2578:
2579: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2572: x_return_status := G_RET_STS_UNEXP_ERROR ;
2573:
2574: WHEN OTHERS THEN
2575: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2576: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_Section_Amend_No_Texts because of EXCEPTION: '||sqlerrm);
2577: END IF;
2578:
2579: x_return_status := G_RET_STS_UNEXP_ERROR ;
2580: END check_section_amend_no_texts;

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

2602: WHERE document_type = p_doc_type;
2603:
2604: BEGIN
2605:
2606: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_article_amend_no_texts');
2608: END IF;
2609:
2610: --Bug 3681462 Check for disable_amend_yn

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

2603:
2604: BEGIN
2605:
2606: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_article_amend_no_texts');
2608: END IF;
2609:
2610: --Bug 3681462 Check for disable_amend_yn
2611: OPEN l_get_doc_disable_amend_csr;

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

2655: END IF; -- IF l_perform_art_amend_qa ='Y' THEN
2656:
2657: END IF; -- l_disable_amend_yn = 'N'
2658:
2659: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2660: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2661: END IF;
2662:
2663: EXCEPTION

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

2656:
2657: END IF; -- l_disable_amend_yn = 'N'
2658:
2659: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2660: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2661: END IF;
2662:
2663: EXCEPTION
2664: WHEN FND_API.G_EXC_ERROR THEN

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

2661: END IF;
2662:
2663: EXCEPTION
2664: WHEN FND_API.G_EXC_ERROR THEN
2665: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: 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');
2667: END IF;
2668:
2669: x_return_status := G_RET_STS_ERROR ;

Line 2666: 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');

2662:
2663: EXCEPTION
2664: WHEN FND_API.G_EXC_ERROR THEN
2665: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: 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');
2667: END IF;
2668:
2669: x_return_status := G_RET_STS_ERROR ;
2670:

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

2668:
2669: x_return_status := G_RET_STS_ERROR ;
2670:
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: 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');
2674: END IF;
2675:
2676: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 2673: 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');

2669: x_return_status := G_RET_STS_ERROR ;
2670:
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: 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');
2674: END IF;
2675:
2676: x_return_status := G_RET_STS_UNEXP_ERROR ;
2677:

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

2675:
2676: x_return_status := G_RET_STS_UNEXP_ERROR ;
2677:
2678: WHEN OTHERS THEN
2679: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2680: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_article_amend_no_texts because of EXCEPTION: '||sqlerrm);
2681: END IF;
2682:
2683: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

2676: x_return_status := G_RET_STS_UNEXP_ERROR ;
2677:
2678: WHEN OTHERS THEN
2679: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2680: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_article_amend_no_texts because of EXCEPTION: '||sqlerrm);
2681: END IF;
2682:
2683: x_return_status := G_RET_STS_UNEXP_ERROR ;
2684: END check_article_amend_no_texts;

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

2730: AND LANGUAGE = userenv('LANG');
2731:
2732: BEGIN
2733:
2734: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_inactive_template');
2736: END IF;
2737:
2738: get_qa_code_detail(p_qa_code => G_CHECK_TMPL_EFFECTIVITY,

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

2731:
2732: BEGIN
2733:
2734: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_inactive_template');
2736: END IF;
2737:
2738: get_qa_code_detail(p_qa_code => G_CHECK_TMPL_EFFECTIVITY,
2739: x_perform_qa => l_perform_tmpl_qa,

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

2799: END LOOP; -- FOR cr in l_get_template_crs LOOP
2800: END IF; -- IF l_perform_tmpl_qa ='Y' THEN
2801:
2802:
2803: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2804: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');
2805: END IF;
2806:
2807: EXCEPTION

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

2800: END IF; -- IF l_perform_tmpl_qa ='Y' THEN
2801:
2802:
2803: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2804: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');
2805: END IF;
2806:
2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN

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

2805: END IF;
2806:
2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN
2809: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2810: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2811: END IF;
2812:
2813: IF l_get_template_crs%ISOPEN THEN

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

2806:
2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN
2809: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2810: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2811: END IF;
2812:
2813: IF l_get_template_crs%ISOPEN THEN
2814: CLOSE l_get_template_crs;

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

2816:
2817: x_return_status := G_RET_STS_ERROR ;
2818:
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2822: END IF;
2823:
2824: IF l_get_template_crs%ISOPEN THEN

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

2817: x_return_status := G_RET_STS_ERROR ;
2818:
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2822: END IF;
2823:
2824: IF l_get_template_crs%ISOPEN THEN
2825: CLOSE l_get_template_crs;

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

2827:
2828: x_return_status := G_RET_STS_UNEXP_ERROR ;
2829:
2830: WHEN OTHERS THEN
2831: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2832: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_inactive_template because of EXCEPTION: '||sqlerrm);
2833: END IF;
2834:
2835: IF l_get_template_crs%ISOPEN THEN

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

2828: x_return_status := G_RET_STS_UNEXP_ERROR ;
2829:
2830: WHEN OTHERS THEN
2831: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2832: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_inactive_template because of EXCEPTION: '||sqlerrm);
2833: END IF;
2834:
2835: IF l_get_template_crs%ISOPEN THEN
2836: CLOSE l_get_template_crs;

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

3048: ) ;
3049:
3050: BEGIN
3051:
3052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_art_effectivity');
3054: END IF;
3055:
3056: get_qa_code_detail(p_qa_code => G_CHECK_ART_VALIDITY,

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

3049:
3050: BEGIN
3051:
3052: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_art_effectivity');
3054: END IF;
3055:
3056: get_qa_code_detail(p_qa_code => G_CHECK_ART_VALIDITY,
3057: x_perform_qa => l_perform_art_val_qa,

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

3224:
3225: END IF; -- IF l_perform_art_val_qa='Y' OR l_perform_lat_vers_qa='Y'
3226:
3227:
3228: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3229: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3230: END IF;
3231:
3232: EXCEPTION

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

3225: END IF; -- IF l_perform_art_val_qa='Y' OR l_perform_lat_vers_qa='Y'
3226:
3227:
3228: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3229: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3230: END IF;
3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN

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

3230: END IF;
3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN
3234: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3235: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3236: END IF;
3237:
3238: IF l_get_tmpl_dates_csr%ISOPEN THEN

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

3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN
3234: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3235: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3236: END IF;
3237:
3238: IF l_get_tmpl_dates_csr%ISOPEN THEN
3239: CLOSE l_get_tmpl_dates_csr;

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

3256:
3257: x_return_status := G_RET_STS_ERROR ;
3258:
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3262: END IF;
3263:
3264: IF l_get_tmpl_dates_csr%ISOPEN THEN

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

3257: x_return_status := G_RET_STS_ERROR ;
3258:
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3262: END IF;
3263:
3264: IF l_get_tmpl_dates_csr%ISOPEN THEN
3265: CLOSE l_get_tmpl_dates_csr;

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

3282:
3283: x_return_status := G_RET_STS_UNEXP_ERROR ;
3284:
3285: WHEN OTHERS THEN
3286: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3287: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_art_effectivity because of EXCEPTION: '||sqlerrm);
3288: END IF;
3289:
3290: IF l_get_tmpl_dates_csr%ISOPEN THEN

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

3283: x_return_status := G_RET_STS_UNEXP_ERROR ;
3284:
3285: WHEN OTHERS THEN
3286: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3287: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_art_effectivity because of EXCEPTION: '||sqlerrm);
3288: END IF;
3289:
3290: IF l_get_tmpl_dates_csr%ISOPEN THEN
3291: CLOSE l_get_tmpl_dates_csr;

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

3335: WHERE template_id = p_doc_id ;
3336:
3337: BEGIN
3338:
3339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_layout_template');
3341: END IF;
3342: get_qa_code_detail(p_qa_code => G_CHECK_LAYOUT_TMPL,
3343: x_perform_qa => l_perform_layout_tmpl_qa,

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

3336:
3337: BEGIN
3338:
3339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_layout_template');
3341: END IF;
3342: get_qa_code_detail(p_qa_code => G_CHECK_LAYOUT_TMPL,
3343: x_perform_qa => l_perform_layout_tmpl_qa,
3344: x_qa_name => l_desc,

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

3382: END IF;
3383:
3384: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN
3385:
3386: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3387: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3388: END IF;
3389:
3390: EXCEPTION

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

3383:
3384: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN
3385:
3386: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3387: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3388: END IF;
3389:
3390: EXCEPTION
3391: WHEN FND_API.G_EXC_ERROR THEN

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

3388: END IF;
3389:
3390: EXCEPTION
3391: WHEN FND_API.G_EXC_ERROR THEN
3392: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3393: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3394: END IF;
3395:
3396: IF l_get_layout_tmpl_csr%ISOPEN THEN

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

3389:
3390: EXCEPTION
3391: WHEN FND_API.G_EXC_ERROR THEN
3392: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3393: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3394: END IF;
3395:
3396: IF l_get_layout_tmpl_csr%ISOPEN THEN
3397: CLOSE l_get_layout_tmpl_csr;

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

3399:
3400: x_return_status := G_RET_STS_ERROR ;
3401:
3402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3403: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3405: END IF;
3406:
3407: IF l_get_layout_tmpl_csr%ISOPEN THEN

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

3400: x_return_status := G_RET_STS_ERROR ;
3401:
3402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3403: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3405: END IF;
3406:
3407: IF l_get_layout_tmpl_csr%ISOPEN THEN
3408: CLOSE l_get_layout_tmpl_csr;

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

3410:
3411: x_return_status := G_RET_STS_UNEXP_ERROR ;
3412:
3413: WHEN OTHERS THEN
3414: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_layout_template because of EXCEPTION: '||sqlerrm);
3416: END IF;
3417:
3418: IF l_get_layout_tmpl_csr%ISOPEN THEN

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

3411: x_return_status := G_RET_STS_UNEXP_ERROR ;
3412:
3413: WHEN OTHERS THEN
3414: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3415: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_layout_template because of EXCEPTION: '||sqlerrm);
3416: END IF;
3417:
3418: IF l_get_layout_tmpl_csr%ISOPEN THEN
3419: CLOSE l_get_layout_tmpl_csr;

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

3457:
3458:
3459: BEGIN
3460:
3461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_revision');
3463: END IF;
3464: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_REVISION,
3465: x_perform_qa => l_perform_trans_rev_qa,

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

3458:
3459: BEGIN
3460:
3461: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3462: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_revision');
3463: END IF;
3464: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_REVISION,
3465: x_perform_qa => l_perform_trans_rev_qa,
3466: x_qa_name => l_desc,

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

3504: END IF;
3505:
3506: END IF;
3507:
3508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3510: END IF;
3511:
3512: EXCEPTION

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

3505:
3506: END IF;
3507:
3508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3510: END IF;
3511:
3512: EXCEPTION
3513: WHEN FND_API.G_EXC_ERROR THEN

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

3510: END IF;
3511:
3512: EXCEPTION
3513: WHEN FND_API.G_EXC_ERROR THEN
3514: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3515: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3516: END IF;
3517:
3518: IF l_translated_tmpl_revision_csr%ISOPEN THEN

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

3511:
3512: EXCEPTION
3513: WHEN FND_API.G_EXC_ERROR THEN
3514: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3515: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3516: END IF;
3517:
3518: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3519: CLOSE l_translated_tmpl_revision_csr;

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

3521:
3522: x_return_status := G_RET_STS_ERROR ;
3523:
3524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3525: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3526: 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');
3527: END IF;
3528:
3529: IF l_translated_tmpl_revision_csr%ISOPEN THEN

Line 3526: 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');

3522: x_return_status := G_RET_STS_ERROR ;
3523:
3524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3525: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3526: 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');
3527: END IF;
3528:
3529: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3530: CLOSE l_translated_tmpl_revision_csr;

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

3532:
3533: x_return_status := G_RET_STS_UNEXP_ERROR ;
3534:
3535: WHEN OTHERS THEN
3536: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3537: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_revision because of EXCEPTION: '||sqlerrm);
3538: END IF;
3539:
3540: IF l_translated_tmpl_revision_csr%ISOPEN THEN

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

3533: x_return_status := G_RET_STS_UNEXP_ERROR ;
3534:
3535: WHEN OTHERS THEN
3536: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3537: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_revision because of EXCEPTION: '||sqlerrm);
3538: END IF;
3539:
3540: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3541: CLOSE l_translated_tmpl_revision_csr;

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

3579:
3580:
3581: BEGIN
3582:
3583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_effectivity');
3585: END IF;
3586: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_EFF,
3587: x_perform_qa => l_perform_trans_tmpl_eff_qa,

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

3580:
3581: BEGIN
3582:
3583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered Check_translated_tmpl_effectivity');
3585: END IF;
3586: get_qa_code_detail(p_qa_code => G_CHECK_TRANS_TMPL_EFF,
3587: x_perform_qa => l_perform_trans_tmpl_eff_qa,
3588: x_qa_name => l_desc,

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

3626: END IF;
3627:
3628: END IF;
3629:
3630: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3632: END IF;
3633:
3634: EXCEPTION

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

3627:
3628: END IF;
3629:
3630: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3632: END IF;
3633:
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN

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

3632: END IF;
3633:
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3637: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3638: END IF;
3639:
3640: IF l_get_trans_tmpl_csr%ISOPEN THEN

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

3633:
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3637: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3638: END IF;
3639:
3640: IF l_get_trans_tmpl_csr%ISOPEN THEN
3641: CLOSE l_get_trans_tmpl_csr;

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

3643:
3644: x_return_status := G_RET_STS_ERROR ;
3645:
3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3647: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: 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');
3649: END IF;
3650:
3651: IF l_get_trans_tmpl_csr%ISOPEN THEN

Line 3648: 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');

3644: x_return_status := G_RET_STS_ERROR ;
3645:
3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3647: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: 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');
3649: END IF;
3650:
3651: IF l_get_trans_tmpl_csr%ISOPEN THEN
3652: CLOSE l_get_trans_tmpl_csr;

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

3654:
3655: x_return_status := G_RET_STS_UNEXP_ERROR ;
3656:
3657: WHEN OTHERS THEN
3658: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3659: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_effectivity because of EXCEPTION: '||sqlerrm);
3660: END IF;
3661:
3662: IF l_get_trans_tmpl_csr%ISOPEN THEN

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

3655: x_return_status := G_RET_STS_UNEXP_ERROR ;
3656:
3657: WHEN OTHERS THEN
3658: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3659: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Check_translated_tmpl_effectivity because of EXCEPTION: '||sqlerrm);
3660: END IF;
3661:
3662: IF l_get_trans_tmpl_csr%ISOPEN THEN
3663: CLOSE l_get_trans_tmpl_csr;

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

3689: l_perform_articles_exist_qa VARCHAR2(1);
3690:
3691: BEGIN
3692:
3693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_articles_exist');
3695: END IF;
3696:
3697: get_qa_code_detail(p_qa_code => G_CHECK_ART_EXT,

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

3690:
3691: BEGIN
3692:
3693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_articles_exist');
3695: END IF;
3696:
3697: get_qa_code_detail(p_qa_code => G_CHECK_ART_EXT,
3698: x_perform_qa => l_perform_articles_exist_qa,

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

3738: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3739: END IF;
3740:
3741:
3742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3744: END IF;
3745:
3746: EXCEPTION

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

3739: END IF;
3740:
3741:
3742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3744: END IF;
3745:
3746: EXCEPTION
3747: WHEN FND_API.G_EXC_ERROR THEN

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

3744: END IF;
3745:
3746: EXCEPTION
3747: WHEN FND_API.G_EXC_ERROR THEN
3748: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3749: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3750: END IF;
3751:
3752: x_return_status := G_RET_STS_ERROR ;

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

3745:
3746: EXCEPTION
3747: WHEN FND_API.G_EXC_ERROR THEN
3748: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3749: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3750: END IF;
3751:
3752: x_return_status := G_RET_STS_ERROR ;
3753:

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

3751:
3752: x_return_status := G_RET_STS_ERROR ;
3753:
3754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3755: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3756: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3757: END IF;
3758:
3759: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3752: x_return_status := G_RET_STS_ERROR ;
3753:
3754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3755: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3756: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3757: END IF;
3758:
3759: x_return_status := G_RET_STS_UNEXP_ERROR ;
3760:

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

3758:
3759: x_return_status := G_RET_STS_UNEXP_ERROR ;
3760:
3761: WHEN OTHERS THEN
3762: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3763: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_articles_exist because of EXCEPTION: '||sqlerrm);
3764: END IF;
3765:
3766: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

3759: x_return_status := G_RET_STS_UNEXP_ERROR ;
3760:
3761: WHEN OTHERS THEN
3762: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3763: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_articles_exist because of EXCEPTION: '||sqlerrm);
3764: END IF;
3765:
3766: x_return_status := G_RET_STS_UNEXP_ERROR ;
3767:

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

3883: END get_art_title_sec;
3884:
3885: BEGIN
3886:
3887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3888: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_validate_draft_articles');
3889: END IF;
3890:
3891: IF (p_doc_type <> 'TEMPLATE') THEN

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

3884:
3885: BEGIN
3886:
3887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3888: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_validate_draft_articles');
3889: END IF;
3890:
3891: IF (p_doc_type <> 'TEMPLATE') THEN
3892: RETURN; -- no other doc type is supported.

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

4191: END LOOP;
4192: END IF;
4193:
4194:
4195: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4197: END IF;
4198:
4199: EXCEPTION

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

4192: END IF;
4193:
4194:
4195: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4197: END IF;
4198:
4199: EXCEPTION
4200: WHEN FND_API.G_EXC_ERROR THEN

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

4197: END IF;
4198:
4199: EXCEPTION
4200: WHEN FND_API.G_EXC_ERROR THEN
4201: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4202: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4203: END IF;
4204:
4205: IF l_draft_art_csr%ISOPEN THEN

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

4198:
4199: EXCEPTION
4200: WHEN FND_API.G_EXC_ERROR THEN
4201: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4202: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4203: END IF;
4204:
4205: IF l_draft_art_csr%ISOPEN THEN
4206: CLOSE l_draft_art_csr;

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

4208:
4209: x_return_status := G_RET_STS_ERROR ;
4210:
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4213: 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');
4214: END IF;
4215:
4216: IF l_draft_art_csr%ISOPEN THEN

Line 4213: 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');

4209: x_return_status := G_RET_STS_ERROR ;
4210:
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4213: 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');
4214: END IF;
4215:
4216: IF l_draft_art_csr%ISOPEN THEN
4217: CLOSE l_draft_art_csr;

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

4219:
4220: x_return_status := G_RET_STS_UNEXP_ERROR ;
4221:
4222: WHEN OTHERS THEN
4223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_validate_draft_articles because of EXCEPTION: '||sqlerrm);
4225: END IF;
4226:
4227: IF l_draft_art_csr%ISOPEN THEN

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

4220: x_return_status := G_RET_STS_UNEXP_ERROR ;
4221:
4222: WHEN OTHERS THEN
4223: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4224: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_validate_draft_articles because of EXCEPTION: '||sqlerrm);
4225: END IF;
4226:
4227: IF l_draft_art_csr%ISOPEN THEN
4228: CLOSE l_draft_art_csr;

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

4270: AND VER.article_status='REJECTED';
4271:
4272: BEGIN
4273:
4274: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4275: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_rejected_clauses');
4276: END IF;
4277:
4278: IF (p_doc_type <> 'TEMPLATE') THEN

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

4271:
4272: BEGIN
4273:
4274: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4275: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1500: Entered check_rejected_clauses');
4276: END IF;
4277:
4278: IF (p_doc_type <> 'TEMPLATE') THEN
4279: RETURN; -- no other doc type is supported.

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

4318: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4321: END LOOP;
4322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4324: END IF;
4325:
4326: EXCEPTION

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

4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4321: END LOOP;
4322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4324: END IF;
4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN

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

4324: END IF;
4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN
4328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4330: END IF;
4331:
4332: IF l_rejected_art_csr%ISOPEN THEN

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

4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN
4328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4330: END IF;
4331:
4332: IF l_rejected_art_csr%ISOPEN THEN
4333: CLOSE l_rejected_art_csr;

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

4335:
4336: x_return_status := G_RET_STS_ERROR ;
4337:
4338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4339: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4340: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4341: END IF;
4342:
4343: IF l_rejected_art_csr%ISOPEN THEN

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

4336: x_return_status := G_RET_STS_ERROR ;
4337:
4338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4339: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4340: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4341: END IF;
4342:
4343: IF l_rejected_art_csr%ISOPEN THEN
4344: CLOSE l_rejected_art_csr;

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

4346:
4347: x_return_status := G_RET_STS_UNEXP_ERROR ;
4348:
4349: WHEN OTHERS THEN
4350: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4351: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_rejected_clauses because of EXCEPTION: '||sqlerrm);
4352: END IF;
4353:
4354: IF l_rejected_art_csr%ISOPEN THEN

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

4347: x_return_status := G_RET_STS_UNEXP_ERROR ;
4348:
4349: WHEN OTHERS THEN
4350: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4351: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving check_rejected_clauses because of EXCEPTION: '||sqlerrm);
4352: END IF;
4353:
4354: IF l_rejected_art_csr%ISOPEN THEN
4355: CLOSE l_rejected_art_csr;

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

4540: -- if p_qa_mode is null then p_qa_mode := G_NORMAL_QA; end if;
4541: -- if p_validation_level is null then p_validation_level := 'A'; end if;
4542: l_now := SYSDATE;
4543:
4544: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4545: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Entered QA_Doc');
4546: END IF;
4547: -- Initialize API return status to success
4548: x_return_status := G_RET_STS_SUCCESS;

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

4541: -- if p_validation_level is null then p_validation_level := 'A'; end if;
4542: l_now := SYSDATE;
4543:
4544: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4545: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Entered QA_Doc');
4546: END IF;
4547: -- Initialize API return status to success
4548: x_return_status := G_RET_STS_SUCCESS;
4549: x_qa_return_status := G_QA_STS_SUCCESS;

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

4550: g_validation_level := p_validation_level;
4551:
4552: IF p_doc_type = G_TMPL_DOC_TYPE THEN
4553:
4554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2110: Opening cursor l_get_effective_date_template');
4556: END IF;
4557: OPEN l_get_effective_date_template;
4558: --FETCH l_get_effective_date_template INTO l_start_date, l_end_date;

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

4551:
4552: IF p_doc_type = G_TMPL_DOC_TYPE THEN
4553:
4554: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4555: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2110: Opening cursor l_get_effective_date_template');
4556: END IF;
4557: OPEN l_get_effective_date_template;
4558: --FETCH l_get_effective_date_template INTO l_start_date, l_end_date;
4559: FETCH l_get_effective_date_template INTO g_start_date, g_end_date,

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

4574: END IF;
4575:
4576: ELSE
4577: -- doc type not Template
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,'2120: Opening cursor l_get_effective_date');
4580: END IF;
4581: OPEN l_get_effective_date;
4582: FETCH l_get_effective_date INTO l_article_effective_date;

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

4575:
4576: ELSE
4577: -- doc type not Template
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,'2120: Opening cursor l_get_effective_date');
4580: END IF;
4581: OPEN l_get_effective_date;
4582: FETCH l_get_effective_date INTO l_article_effective_date;
4583: IF l_get_effective_date%NOTFOUND THEN

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

4598: l_xprt_article_tbl.DELETE;
4599: */
4600:
4601: -- Get all QA Detail
4602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4603: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2130: Before FOR cr IN l_get_qa_detail_csr LOOP');
4604: END IF;
4605: q := 0;
4606: FOR cr IN l_get_qa_detail_csr LOOP

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

4599: */
4600:
4601: -- Get all QA Detail
4602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4603: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2130: Before FOR cr IN l_get_qa_detail_csr LOOP');
4604: END IF;
4605: q := 0;
4606: FOR cr IN l_get_qa_detail_csr LOOP
4607:

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

4640:
4641:
4642: -- populate l_article_tbl with all the articles.
4643: IF p_doc_type <> G_TMPL_DOC_TYPE THEN
4644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2140: Before FOR cr IN l_get_doc_articles_csr LOOP');
4646: END IF;
4647: i := 0;
4648: FOR cr IN l_get_doc_articles_csr LOOP

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

4641:
4642: -- populate l_article_tbl with all the articles.
4643: IF p_doc_type <> G_TMPL_DOC_TYPE THEN
4644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2140: Before FOR cr IN l_get_doc_articles_csr LOOP');
4646: END IF;
4647: i := 0;
4648: FOR cr IN l_get_doc_articles_csr LOOP
4649: i := i+1;

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

4659: ELSE
4660: -- doc type is TEMPLATE, if expert enabled get the expert clauses
4661: /* expert commented out
4662: IF (g_expert_enabled = 'Y') then
4663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4664: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2150: Before OPEN l_get_xprt_articles_csr');
4665: END IF;
4666: OPEN l_get_xprt_articles_csr;
4667: FETCH l_get_xprt_articles_csr BULK COLLECT INTO l_xprt_article_tbl;

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

4660: -- doc type is TEMPLATE, if expert enabled get the expert clauses
4661: /* expert commented out
4662: IF (g_expert_enabled = 'Y') then
4663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4664: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2150: Before OPEN l_get_xprt_articles_csr');
4665: END IF;
4666: OPEN l_get_xprt_articles_csr;
4667: FETCH l_get_xprt_articles_csr BULK COLLECT INTO l_xprt_article_tbl;
4668: CLOSE l_get_xprt_articles_csr;

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

4668: CLOSE l_get_xprt_articles_csr;
4669: END IF;
4670: */
4671:
4672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2160: Before FOR cr IN l_get_tmpl_articles_csr');
4674: END IF;
4675: i := 0;
4676: FOR cr IN l_get_tmpl_articles_csr LOOP

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

4669: END IF;
4670: */
4671:
4672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2160: Before FOR cr IN l_get_tmpl_articles_csr');
4674: END IF;
4675: i := 0;
4676: FOR cr IN l_get_tmpl_articles_csr LOOP
4677: i := i+1;

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

4686: END LOOP;
4687: END IF;
4688:
4689: -- populate l_section_tbl with all the sections.
4690: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2170: Before FOR cr IN l_get_sections_csr LOOP');
4692: END IF;
4693: i := 0;
4694: FOR cr IN l_get_sections_csr LOOP

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

4687: END IF;
4688:
4689: -- populate l_section_tbl with all the sections.
4690: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2170: Before FOR cr IN l_get_sections_csr LOOP');
4692: END IF;
4693: i := 0;
4694: FOR cr IN l_get_sections_csr LOOP
4695: i := i+1;

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

4708: ------------------------------------------------------------
4709: -- QA Check for Layout Template to be run for templates ONLY
4710: ------------------------------------------------------------
4711: IF p_doc_type=G_TMPL_DOC_TYPE THEN
4712: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4713: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2180: calling check_layout_template');
4714: END IF;
4715: check_layout_template(
4716: p_doc_type => p_doc_type,

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

4709: -- QA Check for Layout Template to be run for templates ONLY
4710: ------------------------------------------------------------
4711: IF p_doc_type=G_TMPL_DOC_TYPE THEN
4712: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4713: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2180: calling check_layout_template');
4714: END IF;
4715: check_layout_template(
4716: p_doc_type => p_doc_type,
4717: p_doc_id => p_doc_id,

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

4724: RAISE FND_API.G_EXC_ERROR ;
4725: END IF;
4726:
4727: --call new internal procedure to check for article existence
4728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2190: calling check_articles_exist');
4730: END IF;
4731: check_articles_exist (
4732: p_doc_type => p_doc_type,

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

4725: END IF;
4726:
4727: --call new internal procedure to check for article existence
4728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2190: calling check_articles_exist');
4730: END IF;
4731: check_articles_exist (
4732: p_doc_type => p_doc_type,
4733: p_doc_id => p_doc_id,

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

4740: RAISE FND_API.G_EXC_ERROR ;
4741: END IF;
4742:
4743: --call new internal procedure to validate any draft articles
4744: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4745: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_validate_draft_articles');
4746: END IF;
4747: check_validate_draft_articles(
4748: p_doc_type => p_doc_type,

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

4741: END IF;
4742:
4743: --call new internal procedure to validate any draft articles
4744: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4745: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_validate_draft_articles');
4746: END IF;
4747: check_validate_draft_articles(
4748: p_doc_type => p_doc_type,
4749: p_doc_id => p_doc_id,

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

4757: END IF;
4758:
4759: -- For Bug# 6979012
4760: --call new internal procedure to give a warning for rejected articles
4761: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4762: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_rejected_clauses');
4763: END IF;
4764: check_rejected_clauses(
4765: p_doc_type => p_doc_type,

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

4758:
4759: -- For Bug# 6979012
4760: --call new internal procedure to give a warning for rejected articles
4761: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4762: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2200: calling check_rejected_clauses');
4763: END IF;
4764: check_rejected_clauses(
4765: p_doc_type => p_doc_type,
4766: p_doc_id => p_doc_id,

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

4774: END IF;
4775: -- Changes for Bug# 6979012 Ends
4776:
4777: --MLS for templates
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,'2202: calling Check_translated_tmpl_revision');
4780: END IF;
4781: Check_translated_tmpl_rev(
4782: p_doc_type => p_doc_type,

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

4775: -- Changes for Bug# 6979012 Ends
4776:
4777: --MLS for templates
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,'2202: calling Check_translated_tmpl_revision');
4780: END IF;
4781: Check_translated_tmpl_rev(
4782: p_doc_type => p_doc_type,
4783: p_doc_id => p_doc_id,

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

4789: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4790: RAISE FND_API.G_EXC_ERROR ;
4791: END IF;
4792:
4793: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');
4795: END IF;
4796: Check_translated_tmpl_eff(
4797: p_doc_type => p_doc_type,

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

4790: RAISE FND_API.G_EXC_ERROR ;
4791: END IF;
4792:
4793: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');
4795: END IF;
4796: Check_translated_tmpl_eff(
4797: p_doc_type => p_doc_type,
4798: p_doc_id => p_doc_id,

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

4812:
4813: --------------------------------------------
4814: -- QA Check for Incompatible articles
4815: --------------------------------------------
4816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2210: calling check_validate_draft_articles');
4818: END IF;
4819: Check_Incomp_and_alternate(
4820: p_qa_mode => p_qa_mode,

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

4813: --------------------------------------------
4814: -- QA Check for Incompatible articles
4815: --------------------------------------------
4816: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4817: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2210: calling check_validate_draft_articles');
4818: END IF;
4819: Check_Incomp_and_alternate(
4820: p_qa_mode => p_qa_mode,
4821: p_doc_type => p_doc_type,

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

4831:
4832: --------------------------------------------
4833: -- QA Check for Duplicate articles
4834: --------------------------------------------
4835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2220: calling Check_duplicate_articles');
4837: END IF;
4838: Check_duplicate_articles(
4839: p_qa_mode => p_qa_mode,

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

4832: --------------------------------------------
4833: -- QA Check for Duplicate articles
4834: --------------------------------------------
4835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2220: calling Check_duplicate_articles');
4837: END IF;
4838: Check_duplicate_articles(
4839: p_qa_mode => p_qa_mode,
4840: p_doc_type => p_doc_type,

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

4850:
4851: --------------------------------------------
4852: -- QA Check for variable-doc type usage
4853: --------------------------------------------
4854: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4855: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2230: calling Check_var_doc_type_usage');
4856: END IF;
4857: Check_var_doc_type_usage(
4858: p_qa_mode => p_qa_mode,

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

4851: --------------------------------------------
4852: -- QA Check for variable-doc type usage
4853: --------------------------------------------
4854: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4855: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2230: calling Check_var_doc_type_usage');
4856: END IF;
4857: Check_var_doc_type_usage(
4858: p_qa_mode => p_qa_mode,
4859: p_doc_type => p_doc_type,

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

4869:
4870: ----------------------------------------------------------------
4871: -- QA Check for article effectivity and old version of article
4872: ----------------------------------------------------------------
4873: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4874: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2240: calling Check_art_effectivity');
4875: END IF;
4876: Check_art_effectivity(
4877: p_qa_mode => p_qa_mode,

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

4870: ----------------------------------------------------------------
4871: -- QA Check for article effectivity and old version of article
4872: ----------------------------------------------------------------
4873: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4874: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2240: calling Check_art_effectivity');
4875: END IF;
4876: Check_art_effectivity(
4877: p_qa_mode => p_qa_mode,
4878: p_doc_type => p_doc_type,

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

4894:
4895: --------------------------------------------
4896: -- QA Check for User Variables
4897: --------------------------------------------
4898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4899: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2250: calling Check_variables');
4900: END IF;
4901: Check_variables(
4902: p_doc_type => p_doc_type,

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

4895: --------------------------------------------
4896: -- QA Check for User Variables
4897: --------------------------------------------
4898: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4899: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2250: calling Check_variables');
4900: END IF;
4901: Check_variables(
4902: p_doc_type => p_doc_type,
4903: p_doc_id => p_doc_id,

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

4912:
4913: ---------------------------------------------------------
4914: -- QA Check for unassigned articles
4915: ---------------------------------------------------------
4916: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4917: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2260: calling Check_unassigned_articles');
4918: END IF;
4919: Check_unassigned_articles(
4920: p_doc_type => p_doc_type,

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

4913: ---------------------------------------------------------
4914: -- QA Check for unassigned articles
4915: ---------------------------------------------------------
4916: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4917: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2260: calling Check_unassigned_articles');
4918: END IF;
4919: Check_unassigned_articles(
4920: p_doc_type => p_doc_type,
4921: p_doc_id => p_doc_id,

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

4930:
4931: ---------------------------------------------------------------
4932: -- QA Check for empty sections
4933: ---------------------------------------------------------------
4934: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4935: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2270: calling Check_empty_sections');
4936: END IF;
4937: Check_empty_sections(
4938: p_doc_type => p_doc_type,

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

4931: ---------------------------------------------------------------
4932: -- QA Check for empty sections
4933: ---------------------------------------------------------------
4934: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4935: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2270: calling Check_empty_sections');
4936: END IF;
4937: Check_empty_sections(
4938: p_doc_type => p_doc_type,
4939: p_doc_id => p_doc_id,

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

4948:
4949: ---------------------------------------------------------------
4950: -- QA Check for inactive template
4951: ---------------------------------------------------------------
4952: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4953: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2280: calling check_inactive_template');
4954: END IF;
4955: check_inactive_template(
4956: p_doc_type => p_doc_type,

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

4949: ---------------------------------------------------------------
4950: -- QA Check for inactive template
4951: ---------------------------------------------------------------
4952: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4953: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2280: calling check_inactive_template');
4954: END IF;
4955: check_inactive_template(
4956: p_doc_type => p_doc_type,
4957: p_doc_id => p_doc_id,

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

4968:
4969: ------------------------------------------------------------
4970: -- QA Check for Amended article with no description
4971: ------------------------------------------------------------
4972: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4973: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2290: calling Check_article_Amend_No_Texts');
4974: END IF;
4975: Check_article_Amend_No_Texts(
4976: p_doc_type => p_doc_type,

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

4969: ------------------------------------------------------------
4970: -- QA Check for Amended article with no description
4971: ------------------------------------------------------------
4972: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4973: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2290: calling Check_article_Amend_No_Texts');
4974: END IF;
4975: Check_article_Amend_No_Texts(
4976: p_doc_type => p_doc_type,
4977: p_doc_id => p_doc_id,

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

4986:
4987: ------------------------------------------------------------
4988: -- QA Check for Amended section with no description
4989: ------------------------------------------------------------
4990: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: calling Check_Section_Amend_No_Texts');
4992: END IF;
4993: Check_Section_Amend_No_Texts(
4994: p_doc_type => p_doc_type,

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

4987: ------------------------------------------------------------
4988: -- QA Check for Amended section with no description
4989: ------------------------------------------------------------
4990: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: calling Check_Section_Amend_No_Texts');
4992: END IF;
4993: Check_Section_Amend_No_Texts(
4994: p_doc_type => p_doc_type,
4995: p_doc_id => p_doc_id,

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

5008:
5009: ------------------------------------------------------------
5010: -- QA Check for expert
5011: ------------------------------------------------------------
5012: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5013: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2310: calling OKC_EXPRT_UTIL_GRP.contract_expert_bv');
5014: END IF;
5015:
5016: IF p_doc_type = G_TMPL_DOC_TYPE THEN

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

5009: ------------------------------------------------------------
5010: -- QA Check for expert
5011: ------------------------------------------------------------
5012: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5013: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2310: calling OKC_EXPRT_UTIL_GRP.contract_expert_bv');
5014: END IF;
5015:
5016: IF p_doc_type = G_TMPL_DOC_TYPE THEN
5017: --Added 11.5.10+ CE

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

5055:
5056: -- update common attributes for the QA table
5057: IF x_qa_result_tbl.COUNT > 0 THEN
5058:
5059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5060: 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');
5061: END IF;
5062:
5063: FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP

Line 5060: 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');

5056: -- update common attributes for the QA table
5057: IF x_qa_result_tbl.COUNT > 0 THEN
5058:
5059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5060: 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');
5061: END IF;
5062:
5063: FOR i IN x_qa_result_tbl.FIRST..x_qa_result_tbl.LAST LOOP
5064: x_qa_result_tbl(i).document_type := p_doc_type;

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

5070: END IF;
5071: IF x_qa_result_tbl(i).Error_severity = G_QA_STS_WARNING THEN
5072: l_warning_found := true;
5073: END IF;
5074: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5075: 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);
5076: END IF;
5077:
5078: END LOOP;

Line 5075: 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);

5071: IF x_qa_result_tbl(i).Error_severity = G_QA_STS_WARNING THEN
5072: l_warning_found := true;
5073: END IF;
5074: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5075: 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);
5076: END IF;
5077:
5078: END LOOP;
5079: IF l_error_found THEN

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

5085:
5086:
5087: END IF; -- IF l_perform_QA then
5088:
5089: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5090: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5091: END IF;
5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5093:

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

5086:
5087: END IF; -- IF l_perform_QA then
5088:
5089: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5090: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
5091: END IF;
5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5093:
5094: EXCEPTION

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

5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5093:
5094: EXCEPTION
5095: WHEN FND_API.G_EXC_ERROR THEN
5096: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5097: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5098: END IF;
5099:
5100: IF l_get_qa_detail_csr%ISOPEN THEN

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

5093:
5094: EXCEPTION
5095: WHEN FND_API.G_EXC_ERROR THEN
5096: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5097: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5098: END IF;
5099:
5100: IF l_get_qa_detail_csr%ISOPEN THEN
5101: CLOSE l_get_qa_detail_csr;

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

5123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5124:
5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5126: ROLLBACK TO g_QA_Doc;
5127: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5128: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5129: END IF;
5130: IF l_get_qa_detail_csr%ISOPEN THEN
5131: CLOSE l_get_qa_detail_csr;

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

5124:
5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5126: ROLLBACK TO g_QA_Doc;
5127: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5128: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5129: END IF;
5130: IF l_get_qa_detail_csr%ISOPEN THEN
5131: CLOSE l_get_qa_detail_csr;
5132: END IF;

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

5152: x_return_status := G_RET_STS_UNEXP_ERROR ;
5153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5154:
5155: WHEN OTHERS THEN
5156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5157: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
5158: END IF;
5159:
5160: IF l_get_qa_detail_csr%ISOPEN THEN

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

5153: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5154:
5155: WHEN OTHERS THEN
5156: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5157: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);
5158: END IF;
5159:
5160: IF l_get_qa_detail_csr%ISOPEN THEN
5161: CLOSE l_get_qa_detail_csr;