DBA Data[Home] [Help]

APPS.OKC_ARTICLES_GRP dependencies on FND_SEQNUM

Line 715: l_result := fnd_seqnum.get_seq_info(

711: END IF;
712: l_row_notfound1 := FALSE;
713: --l_doc_category_code := G_DOC_CATEGORY_CODE; -- Commented for new changes for MOAC
714: --dbms_output.put_line('Org Id:'||p_org_id||'CAT: '||l_doc_category_code||'SOB: '||l_set_of_books_id);
715: l_result := fnd_seqnum.get_seq_info(
716: app_id => 510 ,
717: cat_code => l_doc_category_code,
718: sob_id => l_set_of_books_id,
719: met_code => NULL,

Line 734: IF l_result <> FND_SEQNUM.SEQSUCC THEN

730: suppress_warn => 'Y'
731: );
732: x_doc_sequence_type := l_doc_sequence_type;
733: --dbms_output.put_line('Info result is: '|| l_result ||'*'|| l_doc_sequence_type);
734: IF l_result <> FND_SEQNUM.SEQSUCC THEN
735: /* Commented following IF - Bug 3542035 , This IF is not reqd */
736: --IF l_result = FND_SEQNUM.NOTUSED THEN
737: OKC_API.set_message(G_APP_NAME,'OKC_ART_MISS_DOC_SEQ');
738: --END IF;

Line 736: --IF l_result = FND_SEQNUM.NOTUSED THEN

732: x_doc_sequence_type := l_doc_sequence_type;
733: --dbms_output.put_line('Info result is: '|| l_result ||'*'|| l_doc_sequence_type);
734: IF l_result <> FND_SEQNUM.SEQSUCC THEN
735: /* Commented following IF - Bug 3542035 , This IF is not reqd */
736: --IF l_result = FND_SEQNUM.NOTUSED THEN
737: OKC_API.set_message(G_APP_NAME,'OKC_ART_MISS_DOC_SEQ');
738: --END IF;
739: RAISE FND_API.G_EXC_ERROR;
740: END IF;

Line 749: l_result := fnd_seqnum.get_seq_val(

745: -- Continue with the rest if article number is also desired
746:
747:
748: IF ( x_doc_sequence_type <> 'M') THEN
749: l_result := fnd_seqnum.get_seq_val(
750: app_id => 510,
751: cat_code => l_doc_category_code,
752: sob_id => l_set_of_books_id,
753: met_code => null,