APPS.OKC_CONTRACT_SEQ_PVT dependencies on FND_SEQNUM

Line 352: l_return_status := Fnd_Seqnum.Define_Doc_Seq

348: --
349: select okc_k_seq_lines_s1.nextval into l_seq from dual;
350: l_docseq_name := Fnd_Profile.Value('OKC_DOC_SEQUENCE_NAME') ||
351: To_Char(l_seq);
352: l_return_status := Fnd_Seqnum.Define_Doc_Seq
353: (app_id => 510,
354: docseq_name => l_docseq_name,
355: docseq_type => 'A',
356: msg_flag => 'N',

Line 359: If l_return_status <> FND_SEQNUM.SEQSUCC Then

355: docseq_type => 'A',
356: msg_flag => 'N',
357: init_value => l_lsqv_rec.start_seq_no,
358: p_startdate => sysdate);
359: If l_return_status <> FND_SEQNUM.SEQSUCC Then
360: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
361: RAISE G_EXCEPTION_HALT_VALIDATION;
362: End If;
363: -- Get the document sequence id just generated

Line 437: l_return_status := Fnd_Seqnum.Assign_Doc_Seq

433:
434: --
435: -- Populate the fnd_doc_doc_sequence_assignment table.
436: --
437: l_return_status := Fnd_Seqnum.Assign_Doc_Seq
438: (app_id => 510,
439: docseq_name => l_docseq_name,
440: cat_code => l_docseq_name,
441: sob_id => l_set_of_books_id,

Line 445: If l_return_status <> FND_SEQNUM.SEQSUCC Then

441: sob_id => l_set_of_books_id,
442: met_code => 'A',
443: p_startdate => x_lsqv_rec.creation_date,
444: p_enddate => Null);
445: If l_return_status <> FND_SEQNUM.SEQSUCC Then
446: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
447: RAISE G_EXCEPTION_HALT_VALIDATION;
448: End If;
449: End If;