[Home] [Help]
2: /* $Header: OKLREQXB.pls 120.5.12010000.2 2009/06/14 08:35:56 racheruv ship $ */
3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
5: -------------------------------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'NO_PARENT_RECORD';
25: -----------------------------------------------------------------------------------
26: -- GLOBAL VARIABLES
27: -----------------------------------------------------------------------------------
28: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_EQUIPMENT_EXCHANGE';
29: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
30:
31:
32:
33:
475: --End of Comments
476: ------------------------------------------------------------------------------
477: PROCEDURE get_trx_rec
478: (p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_cle_id IN NUMBER,
483: p_cle_id IN NUMBER,
484: p_transaction_type IN VARCHAR2,
485: x_trx_rec OUT NOCOPY transaction_rec) is
486:
487: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
488: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
489: l_api_version CONSTANT NUMBER := 1.0;
490:
491: --Following cursor assumes that a transaction type called
510:
511: l_trx_type_id NUMBER;
512: Begin
513: -- Bug# 8459840 - Start actvity
514: x_return_status := OKL_API.START_ACTIVITY(
515: l_api_name
516: ,p_init_msg_list
517: ,'_PVT'
518: ,x_return_status);
516: ,p_init_msg_list
517: ,'_PVT'
518: ,x_return_status);
519: --Check if activity started successfully
520: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
517: ,'_PVT'
518: ,x_return_status);
519: --Check if activity started successfully
520: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: -- end bug 8459840
518: ,x_return_status);
519: --Check if activity started successfully
520: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: -- end bug 8459840
526:
519: --Check if activity started successfully
520: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
522: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: -- end bug 8459840
526:
527: open okl_trx_type_curs(p_transaction_type);
528: Fetch okl_trx_type_curs
529: into l_trx_type_id;
530: If okl_trx_type_curs%NotFound Then
531: --OKL LINE ACTIVATION not seeded as a source transaction in IB
532: Raise OKL_API.G_EXCEPTION_ERROR;
533: End If;
534: close okl_trx_type_curs;
535: --Assign transaction Type id to seeded value in cs_lookups
536: x_trx_rec.transaction_type_id := l_trx_type_id;
538: x_trx_rec.source_line_ref_id := p_cle_id;
539: x_trx_rec.transaction_date := sysdate;
540: x_trx_rec.source_transaction_date := sysdate;
541: Exception
542: When OKL_API.G_EXCEPTION_ERROR Then
543: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
544: (
545: l_api_name,
546: G_PKG_NAME,
539: x_trx_rec.transaction_date := sysdate;
540: x_trx_rec.source_transaction_date := sysdate;
541: Exception
542: When OKL_API.G_EXCEPTION_ERROR Then
543: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
544: (
545: l_api_name,
546: G_PKG_NAME,
547: 'OKL_API.G_RET_STS_ERROR',
543: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
544: (
545: l_api_name,
546: G_PKG_NAME,
547: 'OKL_API.G_RET_STS_ERROR',
548: x_msg_count,
549: x_msg_data,
550: '_PVT'
551: );
548: x_msg_count,
549: x_msg_data,
550: '_PVT'
551: );
552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
554: (
555: l_api_name,
556: G_PKG_NAME,
549: x_msg_data,
550: '_PVT'
551: );
552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
554: (
555: l_api_name,
556: G_PKG_NAME,
557: 'OKL_API.G_RET_STS_UNEXP_ERROR',
553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
554: (
555: l_api_name,
556: G_PKG_NAME,
557: 'OKL_API.G_RET_STS_UNEXP_ERROR',
558: x_msg_count,
559: x_msg_data,
560: '_PVT'
561: );
559: x_msg_data,
560: '_PVT'
561: );
562: WHEN OTHERS THEN
563: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
564: (
565: l_api_name,
566: G_PKG_NAME,
567: 'OTHERS',
577:
578: PROCEDURE init_ib_rec(l_instance_rec OUT NOCOPY instance_rec)
579: AS
580: BEGIN
581: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: PROCEDURE init_ib_rec(l_instance_rec OUT NOCOPY instance_rec)
579: AS
580: BEGIN
581: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
579: AS
580: BEGIN
581: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
580: BEGIN
581: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
581: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
582: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
583: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
584: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
585: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
586: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
589: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
591: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
593: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
595: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
596: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
597: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
598: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
599: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
600: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
601: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
602: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
603: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
604: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
605: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
606: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
607: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
608: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
609: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
610: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
612: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
614: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
615: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
616: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
617: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
618: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
619: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
620: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
621: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
622: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
623: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
624: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
625: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
626: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
627: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
628: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
629: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
630: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
631: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
632: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
633: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
634: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
635: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
636: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
637: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
638: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
639: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
640: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
641: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
642: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
650: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
643: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
650: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
651: END init_ib_rec;
644: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
650: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
651: END init_ib_rec;
652:
645: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
650: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
651: END init_ib_rec;
652:
653:
646: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
647: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
648: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
649: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
650: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
651: END init_ib_rec;
652:
653:
654: PROCEDURE update_serial_number(
652:
653:
654: PROCEDURE update_serial_number(
655: p_api_version IN NUMBER,
656: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
657: p_instance_id IN NUMBER,
658: p_instance_name IN VARCHAR2,
659: p_serial_number IN VARCHAR2,
660: p_inventory_item_id IN NUMBER,
667: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SERIAL_NUMBER';
668: l_object_version_number NUMBER;
669: l_instance_rec instance_rec;
670: BEGIN
671: x_return_status := OKL_API.G_RET_STS_SUCCESS;
672:
673: --Call start_activity to create savepoint, check compatibility and initialize message list
674:
675: x_return_status := OKL_API.START_ACTIVITY(
671: x_return_status := OKL_API.G_RET_STS_SUCCESS;
672:
673: --Call start_activity to create savepoint, check compatibility and initialize message list
674:
675: x_return_status := OKL_API.START_ACTIVITY(
676: l_api_name
677: ,p_init_msg_list
678: ,'_PUB'
679: ,x_return_status);
679: ,x_return_status);
680:
681: --Check if activity started successfully
682:
683: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
686: RAISE OKL_API.G_EXCEPTION_ERROR;
687: END IF;
680:
681: --Check if activity started successfully
682:
683: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
686: RAISE OKL_API.G_EXCEPTION_ERROR;
687: END IF;
688:
681: --Check if activity started successfully
682:
683: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
686: RAISE OKL_API.G_EXCEPTION_ERROR;
687: END IF;
688:
689: --Doing this temporarily, need to talk Ashish about some patch to be installed.
682:
683: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
685: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
686: RAISE OKL_API.G_EXCEPTION_ERROR;
687: END IF;
688:
689: --Doing this temporarily, need to talk Ashish about some patch to be installed.
690:
722: x_return_status => x_return_status,
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data);
725:
726: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data);
725:
726: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731:
724: x_msg_data => x_msg_data);
725:
726: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731:
732: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
725:
726: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731:
732: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
733: EXCEPTION
728: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731:
732: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
733: EXCEPTION
734: WHEN OKL_API.G_EXCEPTION_ERROR THEN
735: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
736: l_api_name,
730: END IF;
731:
732: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
733: EXCEPTION
734: WHEN OKL_API.G_EXCEPTION_ERROR THEN
735: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
736: l_api_name,
737: G_PKG_NAME,
738: 'OKL_API.G_RET_STS_ERROR',
731:
732: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
733: EXCEPTION
734: WHEN OKL_API.G_EXCEPTION_ERROR THEN
735: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
736: l_api_name,
737: G_PKG_NAME,
738: 'OKL_API.G_RET_STS_ERROR',
739: x_msg_count,
734: WHEN OKL_API.G_EXCEPTION_ERROR THEN
735: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
736: l_api_name,
737: G_PKG_NAME,
738: 'OKL_API.G_RET_STS_ERROR',
739: x_msg_count,
740: x_msg_data,
741: '_PUB');
742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
738: 'OKL_API.G_RET_STS_ERROR',
739: x_msg_count,
740: x_msg_data,
741: '_PUB');
742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
743: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
744: l_api_name,
745: G_PKG_NAME,
746: 'OKL_API.G_RET_STS_UNEXP_ERROR',
739: x_msg_count,
740: x_msg_data,
741: '_PUB');
742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
743: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
744: l_api_name,
745: G_PKG_NAME,
746: 'OKL_API.G_RET_STS_UNEXP_ERROR',
747: x_msg_count,
742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
743: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
744: l_api_name,
745: G_PKG_NAME,
746: 'OKL_API.G_RET_STS_UNEXP_ERROR',
747: x_msg_count,
748: x_msg_data,
749: '_PUB');
750: WHEN OTHERS THEN
747: x_msg_count,
748: x_msg_data,
749: '_PUB');
750: WHEN OTHERS THEN
751: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
752: l_api_name,
753: G_PKG_NAME,
754: 'OTHERS',
755: x_msg_count,
762:
763:
764: PROCEDURE Update_item_description(
765: p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
767: x_return_status OUT NOCOPY VARCHAR2,
768: x_msg_count OUT NOCOPY NUMBER,
769: x_msg_data OUT NOCOPY VARCHAR2,
770: p_dnz_chr_id IN NUMBER,
789: l_parent_line_id NUMBER;
790: --akrangan bug 5362977 end
791:
792: BEGIN
793: x_return_status := OKL_API.G_RET_STS_SUCCESS;
794:
795:
796: --Call start_activity to create savepoint, check compatibility and initialize message list
797:
794:
795:
796: --Call start_activity to create savepoint, check compatibility and initialize message list
797:
798: x_return_status := OKL_API.START_ACTIVITY(
799: l_api_name
800: ,p_init_msg_list
801: ,'_PUB'
802: ,x_return_status);
802: ,x_return_status);
803:
804: --Check if activity started successfully
805:
806: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_ERROR;
810: END IF;
803:
804: --Check if activity started successfully
805:
806: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_ERROR;
810: END IF;
811:
804: --Check if activity started successfully
805:
806: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_ERROR;
810: END IF;
811:
812: l_klev_rec.id := p_parent_line_id;
805:
806: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
809: RAISE OKL_API.G_EXCEPTION_ERROR;
810: END IF;
811:
812: l_klev_rec.id := p_parent_line_id;
813:
825: p_klev_rec => l_klev_rec,
826: x_clev_rec => lx_clev_rec,
827: x_klev_rec => lx_klev_rec);
828:
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
826: x_clev_rec => lx_clev_rec,
827: x_klev_rec => lx_klev_rec);
828:
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: --akrangan bug 5362977 start
827: x_klev_rec => lx_klev_rec);
828:
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: --akrangan bug 5362977 start
835: OPEN cr_parent_line_id(p_parent_line_id);
828:
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: --akrangan bug 5362977 start
835: OPEN cr_parent_line_id(p_parent_line_id);
836: FETCH cr_parent_line_id INTO l_parent_line_id;
849: p_klev_rec => l_klev_rec,
850: x_clev_rec => lx_clev_rec,
851: x_klev_rec => lx_klev_rec);
852:
853: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: RAISE OKL_API.G_EXCEPTION_ERROR;
857: END IF;
850: x_clev_rec => lx_clev_rec,
851: x_klev_rec => lx_klev_rec);
852:
853: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: RAISE OKL_API.G_EXCEPTION_ERROR;
857: END IF;
858: --akrangan bug 5362977 end
851: x_klev_rec => lx_klev_rec);
852:
853: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: RAISE OKL_API.G_EXCEPTION_ERROR;
857: END IF;
858: --akrangan bug 5362977 end
859:
852:
853: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: RAISE OKL_API.G_EXCEPTION_ERROR;
857: END IF;
858: --akrangan bug 5362977 end
859:
860: OKL_API.END_ACTIVITY (x_msg_count,
856: RAISE OKL_API.G_EXCEPTION_ERROR;
857: END IF;
858: --akrangan bug 5362977 end
859:
860: OKL_API.END_ACTIVITY (x_msg_count,
861: x_msg_data );
862:
863:
864: EXCEPTION
861: x_msg_data );
862:
863:
864: EXCEPTION
865: WHEN OKL_API.G_EXCEPTION_ERROR THEN
866: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_ERROR',
862:
863:
864: EXCEPTION
865: WHEN OKL_API.G_EXCEPTION_ERROR THEN
866: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_ERROR',
870: x_msg_count,
865: WHEN OKL_API.G_EXCEPTION_ERROR THEN
866: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_ERROR',
870: x_msg_count,
871: x_msg_data,
872: '_PUB');
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
869: 'OKL_API.G_RET_STS_ERROR',
870: x_msg_count,
871: x_msg_data,
872: '_PUB');
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
875: l_api_name,
876: G_PKG_NAME,
877: 'OKL_API.G_RET_STS_UNEXP_ERROR',
870: x_msg_count,
871: x_msg_data,
872: '_PUB');
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
875: l_api_name,
876: G_PKG_NAME,
877: 'OKL_API.G_RET_STS_UNEXP_ERROR',
878: x_msg_count,
873: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
874: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
875: l_api_name,
876: G_PKG_NAME,
877: 'OKL_API.G_RET_STS_UNEXP_ERROR',
878: x_msg_count,
879: x_msg_data,
880: '_PUB');
881: WHEN OTHERS THEN
878: x_msg_count,
879: x_msg_data,
880: '_PUB');
881: WHEN OTHERS THEN
882: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
883: l_api_name,
884: G_PKG_NAME,
885: 'OTHERS',
886: x_msg_count,
907: ---------------------------------------------------------------
908:
909: PROCEDURE store_exchange_details (
910: p_api_version IN NUMBER,
911: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
912: p_thpv_tbl IN thpv_tbl_type,
913: p_old_tlpv_tbl IN tlpv_tbl_type,
914: p_new_tlpv_tbl IN tlpv_tbl_type,
915: p_old_iipv_tbl IN iipv_tbl_type,
945: FROM dual;
946:
947:
948: BEGIN
949: x_return_status := OKL_API.G_RET_STS_SUCCESS;
950:
951: --Call start_activity to create savepoint, check compatibility and initialize message list
952:
953: x_return_status := OKL_API.START_ACTIVITY(
949: x_return_status := OKL_API.G_RET_STS_SUCCESS;
950:
951: --Call start_activity to create savepoint, check compatibility and initialize message list
952:
953: x_return_status := OKL_API.START_ACTIVITY(
954: l_api_name
955: ,p_init_msg_list
956: ,'_PUB'
957: ,x_return_status);
957: ,x_return_status);
958:
959: --Check if activity started successfully
960:
961: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
964: RAISE OKL_API.G_EXCEPTION_ERROR;
965: END IF;
958:
959: --Check if activity started successfully
960:
961: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
964: RAISE OKL_API.G_EXCEPTION_ERROR;
965: END IF;
966:
959: --Check if activity started successfully
960:
961: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
964: RAISE OKL_API.G_EXCEPTION_ERROR;
965: END IF;
966:
967: -- Create the Header Row
960:
961: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
964: RAISE OKL_API.G_EXCEPTION_ERROR;
965: END IF;
966:
967: -- Create the Header Row
968:
977: x_msg_data => x_msg_data,
978: p_thpv_tbl => l_thpv_tbl,
979: x_thpv_tbl => x_thpv_tbl);
980:
981: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF;
978: p_thpv_tbl => l_thpv_tbl,
979: x_thpv_tbl => x_thpv_tbl);
980:
981: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF;
986:
979: x_thpv_tbl => x_thpv_tbl);
980:
981: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF;
986:
987: --populate the TAS_Id to the old lines plsql table.
980:
981: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_ERROR;
985: END IF;
986:
987: --populate the TAS_Id to the old lines plsql table.
988: l_old_tlpv_tbl(1).TAS_ID := x_thpv_tbl(1).ID;
1007: x_msg_data => x_msg_data,
1008: p_tlpv_tbl => l_old_tlpv_tbl,
1009: x_tlpv_tbl => x_old_tlpv_tbl);
1010:
1011: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1008: p_tlpv_tbl => l_old_tlpv_tbl,
1009: x_tlpv_tbl => x_old_tlpv_tbl);
1010:
1011: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1009: x_tlpv_tbl => x_old_tlpv_tbl);
1010:
1011: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1017: --Change done for making serial number optional.
1010:
1011: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1017: --Change done for making serial number optional.
1018: IF l_old_iipv_tbl(1).serial_number is not NULL THEN
1029: x_msg_data => x_msg_data,
1030: p_iipv_tbl => l_old_iipv_tbl,
1031: x_iipv_tbl => x_old_iipv_tbl);
1032:
1033: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1030: p_iipv_tbl => l_old_iipv_tbl,
1031: x_iipv_tbl => x_old_iipv_tbl);
1032:
1033: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1031: x_iipv_tbl => x_old_iipv_tbl);
1032:
1033: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: END IF;
1032:
1033: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: END IF;
1040: --populate the TAS_Id to the new lines plsql table.
1057: x_msg_data => x_msg_data,
1058: p_tlpv_tbl => l_new_tlpv_tbl,
1059: x_tlpv_tbl => x_new_tlpv_tbl);
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1058: p_tlpv_tbl => l_new_tlpv_tbl,
1059: x_tlpv_tbl => x_new_tlpv_tbl);
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1059: x_tlpv_tbl => x_new_tlpv_tbl);
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1067:
1060:
1061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1064: RAISE OKL_API.G_EXCEPTION_ERROR;
1065: END IF;
1066:
1067:
1068: --Change done for making serial number optional
1080: x_msg_data => x_msg_data,
1081: p_iipv_tbl => l_new_iipv_tbl,
1082: x_iipv_tbl => x_new_iipv_tbl);
1083:
1084: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1081: p_iipv_tbl => l_new_iipv_tbl,
1082: x_iipv_tbl => x_new_iipv_tbl);
1083:
1084: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:
1082: x_iipv_tbl => x_new_iipv_tbl);
1083:
1084: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:
1090: END IF;
1083:
1084: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1086: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_ERROR;
1088: END IF;
1089:
1090: END IF;
1091:
1088: END IF;
1089:
1090: END IF;
1091:
1092: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1093: EXCEPTION
1094: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1095: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1096: l_api_name,
1090: END IF;
1091:
1092: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1093: EXCEPTION
1094: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1095: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'OKL_API.G_RET_STS_ERROR',
1091:
1092: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1093: EXCEPTION
1094: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1095: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'OKL_API.G_RET_STS_ERROR',
1099: x_msg_count,
1094: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1095: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'OKL_API.G_RET_STS_ERROR',
1099: x_msg_count,
1100: x_msg_data,
1101: '_PUB');
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1098: 'OKL_API.G_RET_STS_ERROR',
1099: x_msg_count,
1100: x_msg_data,
1101: '_PUB');
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1103: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1104: l_api_name,
1105: G_PKG_NAME,
1106: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1099: x_msg_count,
1100: x_msg_data,
1101: '_PUB');
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1103: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1104: l_api_name,
1105: G_PKG_NAME,
1106: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1107: x_msg_count,
1102: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1103: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1104: l_api_name,
1105: G_PKG_NAME,
1106: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1107: x_msg_count,
1108: x_msg_data,
1109: '_PUB');
1110: WHEN OTHERS THEN
1107: x_msg_count,
1108: x_msg_data,
1109: '_PUB');
1110: WHEN OTHERS THEN
1111: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1112: l_api_name,
1113: G_PKG_NAME,
1114: 'OTHERS',
1115: x_msg_count,
1125:
1126:
1127: PROCEDURE exchange(
1128: p_api_version IN NUMBER,
1129: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
1130: p_tas_id IN NUMBER,
1131: x_return_status OUT NOCOPY VARCHAR2,
1132: x_msg_count OUT NOCOPY NUMBER,
1133: x_msg_data OUT NOCOPY VARCHAR2)
1195:
1196:
1197: BEGIN
1198:
1199: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1200:
1201: --Call start_activity to create savepoint, check compatibility and initialize message list
1202:
1203: x_return_status := OKL_API.START_ACTIVITY(
1199: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1200:
1201: --Call start_activity to create savepoint, check compatibility and initialize message list
1202:
1203: x_return_status := OKL_API.START_ACTIVITY(
1204: l_api_name
1205: ,p_init_msg_list
1206: ,'_PUB'
1207: ,x_return_status);
1207: ,x_return_status);
1208:
1209: --Check if activity started successfully
1210:
1211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1208:
1209: --Check if activity started successfully
1210:
1211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216:
1209: --Check if activity started successfully
1210:
1211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216:
1217: -- probably i might have to take the transaction id/request id and
1210:
1211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1212: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_ERROR;
1215: END IF;
1216:
1217: -- probably i might have to take the transaction id/request id and
1218: -- use it to get the relevant asset details for the new asset and then
1234: p_cvmv_rec => p_cvmv_rec,
1235: x_cvmv_rec => x_cvmv_rec,
1236: p_commit => 'T');
1237:
1238: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1235: x_cvmv_rec => x_cvmv_rec,
1236: p_commit => 'T');
1237:
1238: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1236: p_commit => 'T');
1237:
1238: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1244:
1237:
1238: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1240: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1244:
1245: -- This piece of code is added to fix Bug 2477684
1264: p_asset_number => x_talv_tbl(1).asset_number,
1265: px_asset_desc => l_asset_desc,
1266: px_model_no => x_talv_tbl(1).model_number,
1267: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1268: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1271: RAISE OKL_API.G_EXCEPTION_ERROR;
1272: END IF;
1265: px_asset_desc => l_asset_desc,
1266: px_model_no => x_talv_tbl(1).model_number,
1267: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1268: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1271: RAISE OKL_API.G_EXCEPTION_ERROR;
1272: END IF;
1273:
1266: px_model_no => x_talv_tbl(1).model_number,
1267: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1268: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1271: RAISE OKL_API.G_EXCEPTION_ERROR;
1272: END IF;
1273:
1274:
1267: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1268: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1270: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1271: RAISE OKL_API.G_EXCEPTION_ERROR;
1272: END IF;
1273:
1274:
1275: OPEN c_asset_id1(x_talv_tbl(1).dnz_khr_id,x_talv_tbl(1).dnz_asset_id,x_talv_tbl(1).asset_number);
1288: p_dnz_chr_id => x_talv_tbl(1).dnz_khr_id,
1289: p_parent_line_id => l_id1_okx_asset_lines,
1290: p_year => x_talv_tbl(1).year_manufactured,
1291: x_year => x_year);
1292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1295: RAISE OKL_API.G_EXCEPTION_ERROR;
1296: END IF;
1289: p_parent_line_id => l_id1_okx_asset_lines,
1290: p_year => x_talv_tbl(1).year_manufactured,
1291: x_year => x_year);
1292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1295: RAISE OKL_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: -- END IF;
1290: p_year => x_talv_tbl(1).year_manufactured,
1291: x_year => x_year);
1292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1295: RAISE OKL_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: -- END IF;
1298:
1291: x_year => x_year);
1292: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1294: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1295: RAISE OKL_API.G_EXCEPTION_ERROR;
1296: END IF;
1297: -- END IF;
1298:
1299:
1308: --akrangan bug 5362977 start
1309: --p_item_description => l_item_desc);
1310: p_item_description => l_asset_desc);
1311: --akrangan bug 5362977 end
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1309: --p_item_description => l_item_desc);
1310: p_item_description => l_asset_desc);
1311: --akrangan bug 5362977 end
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:
1310: p_item_description => l_asset_desc);
1311: --akrangan bug 5362977 end
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:
1318:
1311: --akrangan bug 5362977 end
1312: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:
1318:
1319: --change for making sno optional
1332: x_return_status => x_return_status,
1333: x_msg_count => x_msg_count,
1334: x_msg_data => x_msg_data);
1335:
1336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_ERROR;
1340: END IF;
1333: x_msg_count => x_msg_count,
1334: x_msg_data => x_msg_data);
1335:
1336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: end if; -- for p_no_data_found
1334: x_msg_data => x_msg_data);
1335:
1336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: end if; -- for p_no_data_found
1342: ---------------------------------------------------------
1335:
1336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: end if; -- for p_no_data_found
1342: ---------------------------------------------------------
1343: OPEN c_model_line(x_talv_tbl(1).kle_id);
1370: x_cplv_rec => x_cplv_rec);
1371:
1372:
1373:
1374: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1371:
1372:
1373:
1374: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1379: ELSE
1372:
1373:
1374: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1379: ELSE
1380: NULL;
1373:
1374: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1379: ELSE
1380: NULL;
1381:
1384:
1385: -- update the transaction table and set the status to processed or whatever
1386: --If the trx failed then i have to record the reason for failure and send message to the
1387: --concerned person abt this. How do we do this?
1388: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1389: p_thpv_tbl(1).id := p_tas_id;
1390: p_thpv_tbl(1).tsu_code := 'PROCESSED';
1391: okl_trx_assets_pub.update_trx_ass_h_def(
1392: p_api_version => p_api_version,
1400:
1401:
1402:
1403: EXCEPTION
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',
1401:
1402:
1403: EXCEPTION
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',
1409: x_msg_count,
1404: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1406: l_api_name,
1407: G_PKG_NAME,
1408: 'OKL_API.G_RET_STS_ERROR',
1409: x_msg_count,
1410: x_msg_data,
1411: '_PUB');
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1408: 'OKL_API.G_RET_STS_ERROR',
1409: x_msg_count,
1410: x_msg_data,
1411: '_PUB');
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1413: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1409: x_msg_count,
1410: x_msg_data,
1411: '_PUB');
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1413: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1417: x_msg_count,
1412: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1413: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1417: x_msg_count,
1418: x_msg_data,
1419: '_PUB');
1420: WHEN OTHERS THEN
1417: x_msg_count,
1418: x_msg_data,
1419: '_PUB');
1420: WHEN OTHERS THEN
1421: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1422: l_api_name,
1423: G_PKG_NAME,
1424: 'OTHERS',
1425: x_msg_count,