DBA Data[Home] [Help]

APPS.OKC_ARTICLES_GRP dependencies on FND_SEQNUM

Line 726: l_result := fnd_seqnum.get_seq_info(

722: END IF;
723: l_row_notfound1 := FALSE;
724: --l_doc_category_code := G_DOC_CATEGORY_CODE; -- Commented for new changes for MOAC
725: --dbms_output.put_line('Org Id:'||p_org_id||'CAT: '||l_doc_category_code||'SOB: '||l_set_of_books_id);
726: l_result := fnd_seqnum.get_seq_info(
727: app_id => 510 ,
728: cat_code => l_doc_category_code,
729: sob_id => l_set_of_books_id,
730: met_code => NULL,

Line 745: IF l_result <> FND_SEQNUM.SEQSUCC THEN

741: suppress_warn => 'Y'
742: );
743: x_doc_sequence_type := l_doc_sequence_type;
744: --dbms_output.put_line('Info result is: '|| l_result ||'*'|| l_doc_sequence_type);
745: IF l_result <> FND_SEQNUM.SEQSUCC THEN
746: /* Commented following IF - Bug 3542035 , This IF is not reqd */
747: --IF l_result = FND_SEQNUM.NOTUSED THEN
748: OKC_API.set_message(G_APP_NAME,'OKC_ART_MISS_DOC_SEQ');
749: --END IF;

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

743: x_doc_sequence_type := l_doc_sequence_type;
744: --dbms_output.put_line('Info result is: '|| l_result ||'*'|| l_doc_sequence_type);
745: IF l_result <> FND_SEQNUM.SEQSUCC THEN
746: /* Commented following IF - Bug 3542035 , This IF is not reqd */
747: --IF l_result = FND_SEQNUM.NOTUSED THEN
748: OKC_API.set_message(G_APP_NAME,'OKC_ART_MISS_DOC_SEQ');
749: --END IF;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;

Line 760: l_result := fnd_seqnum.get_seq_val(

756: -- Continue with the rest if article number is also desired
757:
758:
759: IF ( x_doc_sequence_type <> 'M') THEN
760: l_result := fnd_seqnum.get_seq_val(
761: app_id => 510,
762: cat_code => l_doc_category_code,
763: sob_id => l_set_of_books_id,
764: met_code => null,