APPS.OKC_CONTRACT_SEQ_PVT dependencies on OKC_API

Line 334: x_return_status := OKC_API.G_RET_STS_SUCCESS;

330: IF (l_debug = 'Y') THEN
331: okc_debug.set_indentation('create_seq_lines');
332: okc_debug.log('2100: Entering create_seq_lines', 2);
333: END IF;
334: x_return_status := OKC_API.G_RET_STS_SUCCESS;
335: -- First check if the same prefix and suffix is already in use
336: Open c1(l_lsqv_rec.line_code,
337: l_lsqv_rec.contract_number_prefix,
338: l_lsqv_rec.contract_number_suffix);

Line 360: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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
364: Open c2;

Line 381: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then

377: x_msg_count,
378: x_msg_data,
379: l_lsqv_rec,
380: x_lsqv_rec);
381: If l_return_status <> OKC_API.G_RET_STS_SUCCESS Then
382: x_return_status := l_return_status;
383: RAISE G_EXCEPTION_HALT_VALIDATION;
384: End If;
385: --

Line 446: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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;
450: IF (l_debug = 'Y') THEN

Line 466: OKC_API.set_message(p_app_name => g_app_name,

462: CLOSE ORG_ID_CSR;
463: END IF;
464: --end npalepu
465: WHEN OTHERS THEN
466: OKC_API.set_message(p_app_name => g_app_name,
467: p_msg_name => g_unexpected_error,
468: p_token1 => g_sqlcode_token,
469: p_token1_value => sqlcode,
470: p_token2 => g_sqlerrm_token,

Line 472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

468: p_token1 => g_sqlcode_token,
469: p_token1_value => sqlcode,
470: p_token2 => g_sqlerrm_token,
471: p_token2_value => sqlerrm);
472: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
473: IF (l_debug = 'Y') THEN
474: okc_debug.log('2400: Exiting create_seq_lines', 2);
475: okc_debug.reset_indentation;
476: END IF;

Line 493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

489: x_msg_data OUT NOCOPY VARCHAR2,
490: p_lsqv_tbl IN lsqv_tbl_type,
491: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type) IS
492: i NUMBER := 0;
493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: BEGIN
495: IF (l_debug = 'Y') THEN
496: okc_debug.set_indentation('create_seq_lines');
497: okc_debug.log('2500: Entering create_seq_lines', 2);

Line 499: x_return_status := OKC_API.G_RET_STS_SUCCESS;

495: IF (l_debug = 'Y') THEN
496: okc_debug.set_indentation('create_seq_lines');
497: okc_debug.log('2500: Entering create_seq_lines', 2);
498: END IF;
499: x_return_status := OKC_API.G_RET_STS_SUCCESS;
500: IF (p_lsqv_tbl.COUNT > 0) THEN
501: i := p_lsqv_tbl.FIRST;
502: LOOP
503: create_seq_lines(

Line 511: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

507: x_msg_count,
508: x_msg_data,
509: p_lsqv_tbl(i),
510: x_lsqv_tbl(i));
511: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: x_return_status := l_return_status;
514: raise G_EXCEPTION_HALT_VALIDATION;
515: ELSE

Line 512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

508: x_msg_data,
509: p_lsqv_tbl(i),
510: x_lsqv_tbl(i));
511: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: x_return_status := l_return_status;
514: raise G_EXCEPTION_HALT_VALIDATION;
515: ELSE
516: x_return_status := l_return_status;

Line 534: OKC_API.set_message(p_app_name => g_app_name,

530: okc_debug.log('2700: Exiting create_seq_lines', 2);
531: okc_debug.reset_indentation;
532: END IF;
533: WHEN OTHERS THEN
534: OKC_API.set_message(p_app_name => g_app_name,
535: p_msg_name => g_unexpected_error,
536: p_token1 => g_sqlcode_token,
537: p_token1_value => sqlcode,
538: p_token2 => g_sqlerrm_token,

Line 540: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

536: p_token1 => g_sqlcode_token,
537: p_token1_value => sqlcode,
538: p_token2 => g_sqlerrm_token,
539: p_token2_value => sqlerrm);
540: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('2800: Exiting create_seq_lines', 2);
543: okc_debug.reset_indentation;
544: END IF;