2: /* $Header: OKLREQXB.pls 120.5 2006/12/05 05:16:42 akrangan noship $ */
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
500: Fetch okl_trx_type_curs
501: into l_trx_type_id;
502: If okl_trx_type_curs%NotFound Then
503: --OKL LINE ACTIVATION not seeded as a source transaction in IB
504: Raise OKL_API.G_EXCEPTION_ERROR;
505: End If;
506: close okl_trx_type_curs;
507: --Assign transaction Type id to seeded value in cs_lookups
508: x_trx_rec.transaction_type_id := l_trx_type_id;
510: x_trx_rec.source_line_ref_id := p_cle_id;
511: x_trx_rec.transaction_date := sysdate;
512: x_trx_rec.source_transaction_date := sysdate;
513: Exception
514: When OKL_API.G_EXCEPTION_ERROR Then
515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
516: (
517: l_api_name,
518: G_PKG_NAME,
511: x_trx_rec.transaction_date := sysdate;
512: x_trx_rec.source_transaction_date := sysdate;
513: Exception
514: When OKL_API.G_EXCEPTION_ERROR Then
515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
516: (
517: l_api_name,
518: G_PKG_NAME,
519: 'OKL_API.G_RET_STS_ERROR',
515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
516: (
517: l_api_name,
518: G_PKG_NAME,
519: 'OKL_API.G_RET_STS_ERROR',
520: x_msg_count,
521: x_msg_data,
522: '_PVT'
523: );
520: x_msg_count,
521: x_msg_data,
522: '_PVT'
523: );
524: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
525: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,
521: x_msg_data,
522: '_PVT'
523: );
524: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
525: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,
529: 'OKL_API.G_RET_STS_UNEXP_ERROR',
525: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,
529: 'OKL_API.G_RET_STS_UNEXP_ERROR',
530: x_msg_count,
531: x_msg_data,
532: '_PVT'
533: );
531: x_msg_data,
532: '_PVT'
533: );
534: WHEN OTHERS THEN
535: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
536: (
537: l_api_name,
538: G_PKG_NAME,
539: 'OTHERS',
549:
550: PROCEDURE init_ib_rec(l_instance_rec OUT NOCOPY instance_rec)
551: AS
552: BEGIN
553: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
550: PROCEDURE init_ib_rec(l_instance_rec OUT NOCOPY instance_rec)
551: AS
552: BEGIN
553: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
551: AS
552: BEGIN
553: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
552: BEGIN
553: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
553: l_instance_rec.INSTANCE_ID := OKL_API.G_MISS_NUM;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
554: l_instance_rec.INSTANCE_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
555: l_instance_rec.EXTERNAL_REFERENCE := OKL_API.G_MISS_CHAR;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
556: l_instance_rec.INVENTORY_ITEM_ID := OKL_API.G_MISS_NUM;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
557: l_instance_rec.VLD_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
558: l_instance_rec.INVENTORY_REVISION := OKL_API.G_MISS_CHAR;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
559: l_instance_rec.INV_MASTER_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
560: l_instance_rec.SERIAL_NUMBER := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
561: l_instance_rec.MFG_SERIAL_NUMBER_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
562: l_instance_rec.LOT_NUMBER := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
563: l_instance_rec.QUANTITY := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
564: l_instance_rec.UNIT_OF_MEASURE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
565: l_instance_rec.ACCOUNTING_CLASS_CODE := OKL_API.G_MISS_CHAR;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
566: l_instance_rec.INSTANCE_CONDITION_ID := OKL_API.G_MISS_NUM;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
567: l_instance_rec.INSTANCE_STATUS_ID := OKL_API.G_MISS_NUM;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
568: l_instance_rec.CUSTOMER_VIEW_FLAG := OKL_API.G_MISS_CHAR;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
569: l_instance_rec.MERCHANT_VIEW_FLAG := OKL_API.G_MISS_CHAR;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
570: l_instance_rec.SELLABLE_FLAG := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
571: l_instance_rec.SYSTEM_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
572: l_instance_rec.INSTANCE_TYPE_CODE := OKL_API.G_MISS_CHAR;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
573: l_instance_rec.ACTIVE_START_DATE := OKL_API.G_MISS_DATE;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
574: l_instance_rec.ACTIVE_END_DATE := OKL_API.G_MISS_DATE;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
575: l_instance_rec.LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
576: l_instance_rec.LOCATION_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
577: l_instance_rec.INV_ORGANIZATION_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
578: l_instance_rec.INV_SUBINVENTORY_NAME := OKL_API.G_MISS_CHAR;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
579: l_instance_rec.INV_LOCATOR_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
580: l_instance_rec.PA_PROJECT_ID := OKL_API.G_MISS_NUM;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
581: l_instance_rec.PA_PROJECT_TASK_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
582: l_instance_rec.IN_TRANSIT_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
583: l_instance_rec.WIP_JOB_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
584: l_instance_rec.PO_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
585: l_instance_rec.LAST_OE_ORDER_LINE_ID := OKL_API.G_MISS_NUM;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
586: l_instance_rec.LAST_OE_RMA_LINE_ID := OKL_API.G_MISS_NUM;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
587: l_instance_rec.LAST_PO_PO_LINE_ID := OKL_API.G_MISS_NUM;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
588: l_instance_rec.LAST_OE_PO_NUMBER := OKL_API.G_MISS_CHAR;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
589: l_instance_rec.LAST_WIP_JOB_ID := OKL_API.G_MISS_NUM;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
590: l_instance_rec.LAST_PA_PROJECT_ID := OKL_API.G_MISS_NUM;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
591: l_instance_rec.LAST_PA_TASK_ID := OKL_API.G_MISS_NUM;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
592: l_instance_rec.LAST_OE_AGREEMENT_ID := OKL_API.G_MISS_NUM;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
593: l_instance_rec.INSTALL_DATE := OKL_API.G_MISS_DATE;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
594: l_instance_rec.MANUALLY_CREATED_FLAG := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
595: l_instance_rec.RETURN_BY_DATE := OKL_API.G_MISS_DATE;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
596: l_instance_rec.ACTUAL_RETURN_DATE := OKL_API.G_MISS_DATE;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
597: l_instance_rec.CREATION_COMPLETE_FLAG := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
598: l_instance_rec.COMPLETENESS_FLAG := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
599: l_instance_rec.VERSION_LABEL := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
600: l_instance_rec.VERSION_LABEL_DESCRIPTION := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
601: l_instance_rec.CONTEXT := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
602: l_instance_rec.ATTRIBUTE1 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
603: l_instance_rec.ATTRIBUTE2 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
604: l_instance_rec.ATTRIBUTE3 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
605: l_instance_rec.ATTRIBUTE4 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
606: l_instance_rec.ATTRIBUTE5 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
607: l_instance_rec.ATTRIBUTE6 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
608: l_instance_rec.ATTRIBUTE7 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
609: l_instance_rec.ATTRIBUTE8 := OKL_API.G_MISS_CHAR;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
610: l_instance_rec.ATTRIBUTE9 := OKL_API.G_MISS_CHAR;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
611: l_instance_rec.ATTRIBUTE10 := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
612: l_instance_rec.ATTRIBUTE11 := OKL_API.G_MISS_CHAR;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
613: l_instance_rec.ATTRIBUTE12 := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
614: l_instance_rec.ATTRIBUTE13 := OKL_API.G_MISS_CHAR;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
622: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
615: l_instance_rec.ATTRIBUTE14 := OKL_API.G_MISS_CHAR;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
622: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
623: END init_ib_rec;
616: l_instance_rec.ATTRIBUTE15 := OKL_API.G_MISS_CHAR;
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
622: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
623: END init_ib_rec;
624:
617: l_instance_rec.OBJECT_VERSION_NUMBER := OKL_API.G_MISS_NUM;
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
622: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
623: END init_ib_rec;
624:
625:
618: l_instance_rec.LAST_TXN_LINE_DETAIL_ID := OKL_API.G_MISS_NUM;
619: l_instance_rec.INSTALL_LOCATION_TYPE_CODE := OKL_API.G_MISS_CHAR;
620: l_instance_rec.INSTALL_LOCATION_ID := OKL_API.G_MISS_NUM;
621: l_instance_rec.INSTANCE_USAGE_CODE := OKL_API.G_MISS_CHAR;
622: l_instance_rec.CHECK_FOR_INSTANCE_EXPIRY := OKL_API.G_TRUE;
623: END init_ib_rec;
624:
625:
626: PROCEDURE update_serial_number(
624:
625:
626: PROCEDURE update_serial_number(
627: p_api_version IN NUMBER,
628: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
629: p_instance_id IN NUMBER,
630: p_instance_name IN VARCHAR2,
631: p_serial_number IN VARCHAR2,
632: p_inventory_item_id IN NUMBER,
639: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_SERIAL_NUMBER';
640: l_object_version_number NUMBER;
641: l_instance_rec instance_rec;
642: BEGIN
643: x_return_status := OKL_API.G_RET_STS_SUCCESS;
644:
645: --Call start_activity to create savepoint, check compatibility and initialize message list
646:
647: x_return_status := OKL_API.START_ACTIVITY(
643: x_return_status := OKL_API.G_RET_STS_SUCCESS;
644:
645: --Call start_activity to create savepoint, check compatibility and initialize message list
646:
647: x_return_status := OKL_API.START_ACTIVITY(
648: l_api_name
649: ,p_init_msg_list
650: ,'_PUB'
651: ,x_return_status);
651: ,x_return_status);
652:
653: --Check if activity started successfully
654:
655: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
652:
653: --Check if activity started successfully
654:
655: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:
653: --Check if activity started successfully
654:
655: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:
661: --Doing this temporarily, need to talk Ashish about some patch to be installed.
654:
655: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:
661: --Doing this temporarily, need to talk Ashish about some patch to be installed.
662:
694: x_return_status => x_return_status,
695: x_msg_count => x_msg_count,
696: x_msg_data => x_msg_data);
697:
698: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
695: x_msg_count => x_msg_count,
696: x_msg_data => x_msg_data);
697:
698: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:
696: x_msg_data => x_msg_data);
697:
698: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:
704: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
697:
698: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
700: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:
704: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
705: EXCEPTION
700: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
701: RAISE OKL_API.G_EXCEPTION_ERROR;
702: END IF;
703:
704: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
705: EXCEPTION
706: WHEN OKL_API.G_EXCEPTION_ERROR THEN
707: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
708: l_api_name,
702: END IF;
703:
704: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
705: EXCEPTION
706: WHEN OKL_API.G_EXCEPTION_ERROR THEN
707: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
708: l_api_name,
709: G_PKG_NAME,
710: 'OKL_API.G_RET_STS_ERROR',
703:
704: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
705: EXCEPTION
706: WHEN OKL_API.G_EXCEPTION_ERROR THEN
707: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
708: l_api_name,
709: G_PKG_NAME,
710: 'OKL_API.G_RET_STS_ERROR',
711: x_msg_count,
706: WHEN OKL_API.G_EXCEPTION_ERROR THEN
707: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
708: l_api_name,
709: G_PKG_NAME,
710: 'OKL_API.G_RET_STS_ERROR',
711: x_msg_count,
712: x_msg_data,
713: '_PUB');
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
710: 'OKL_API.G_RET_STS_ERROR',
711: x_msg_count,
712: x_msg_data,
713: '_PUB');
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
715: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
716: l_api_name,
717: G_PKG_NAME,
718: 'OKL_API.G_RET_STS_UNEXP_ERROR',
711: x_msg_count,
712: x_msg_data,
713: '_PUB');
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
715: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
716: l_api_name,
717: G_PKG_NAME,
718: 'OKL_API.G_RET_STS_UNEXP_ERROR',
719: x_msg_count,
714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
715: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
716: l_api_name,
717: G_PKG_NAME,
718: 'OKL_API.G_RET_STS_UNEXP_ERROR',
719: x_msg_count,
720: x_msg_data,
721: '_PUB');
722: WHEN OTHERS THEN
719: x_msg_count,
720: x_msg_data,
721: '_PUB');
722: WHEN OTHERS THEN
723: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
724: l_api_name,
725: G_PKG_NAME,
726: 'OTHERS',
727: x_msg_count,
734:
735:
736: PROCEDURE Update_item_description(
737: p_api_version IN NUMBER,
738: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2,
742: p_dnz_chr_id IN NUMBER,
761: l_parent_line_id NUMBER;
762: --akrangan bug 5362977 end
763:
764: BEGIN
765: x_return_status := OKL_API.G_RET_STS_SUCCESS;
766:
767:
768: --Call start_activity to create savepoint, check compatibility and initialize message list
769:
766:
767:
768: --Call start_activity to create savepoint, check compatibility and initialize message list
769:
770: x_return_status := OKL_API.START_ACTIVITY(
771: l_api_name
772: ,p_init_msg_list
773: ,'_PUB'
774: ,x_return_status);
774: ,x_return_status);
775:
776: --Check if activity started successfully
777:
778: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_ERROR;
782: END IF;
775:
776: --Check if activity started successfully
777:
778: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:
776: --Check if activity started successfully
777:
778: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:
784: l_klev_rec.id := p_parent_line_id;
777:
778: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
780: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_ERROR;
782: END IF;
783:
784: l_klev_rec.id := p_parent_line_id;
785:
797: p_klev_rec => l_klev_rec,
798: x_clev_rec => lx_clev_rec,
799: x_klev_rec => lx_klev_rec);
800:
801: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
798: x_clev_rec => lx_clev_rec,
799: x_klev_rec => lx_klev_rec);
800:
801: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806: --akrangan bug 5362977 start
799: x_klev_rec => lx_klev_rec);
800:
801: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806: --akrangan bug 5362977 start
807: OPEN cr_parent_line_id(p_parent_line_id);
800:
801: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806: --akrangan bug 5362977 start
807: OPEN cr_parent_line_id(p_parent_line_id);
808: FETCH cr_parent_line_id INTO l_parent_line_id;
821: p_klev_rec => l_klev_rec,
822: x_clev_rec => lx_clev_rec,
823: x_klev_rec => lx_klev_rec);
824:
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
822: x_clev_rec => lx_clev_rec,
823: x_klev_rec => lx_klev_rec);
824:
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --akrangan bug 5362977 end
823: x_klev_rec => lx_klev_rec);
824:
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --akrangan bug 5362977 end
831:
824:
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --akrangan bug 5362977 end
831:
832: OKL_API.END_ACTIVITY (x_msg_count,
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830: --akrangan bug 5362977 end
831:
832: OKL_API.END_ACTIVITY (x_msg_count,
833: x_msg_data );
834:
835:
836: EXCEPTION
833: x_msg_data );
834:
835:
836: EXCEPTION
837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
838: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
839: l_api_name,
840: G_PKG_NAME,
841: 'OKL_API.G_RET_STS_ERROR',
834:
835:
836: EXCEPTION
837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
838: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
839: l_api_name,
840: G_PKG_NAME,
841: 'OKL_API.G_RET_STS_ERROR',
842: x_msg_count,
837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
838: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
839: l_api_name,
840: G_PKG_NAME,
841: 'OKL_API.G_RET_STS_ERROR',
842: x_msg_count,
843: x_msg_data,
844: '_PUB');
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
841: 'OKL_API.G_RET_STS_ERROR',
842: x_msg_count,
843: x_msg_data,
844: '_PUB');
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
846: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
847: l_api_name,
848: G_PKG_NAME,
849: 'OKL_API.G_RET_STS_UNEXP_ERROR',
842: x_msg_count,
843: x_msg_data,
844: '_PUB');
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
846: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
847: l_api_name,
848: G_PKG_NAME,
849: 'OKL_API.G_RET_STS_UNEXP_ERROR',
850: x_msg_count,
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
846: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
847: l_api_name,
848: G_PKG_NAME,
849: 'OKL_API.G_RET_STS_UNEXP_ERROR',
850: x_msg_count,
851: x_msg_data,
852: '_PUB');
853: WHEN OTHERS THEN
850: x_msg_count,
851: x_msg_data,
852: '_PUB');
853: WHEN OTHERS THEN
854: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
855: l_api_name,
856: G_PKG_NAME,
857: 'OTHERS',
858: x_msg_count,
879: ---------------------------------------------------------------
880:
881: PROCEDURE store_exchange_details (
882: p_api_version IN NUMBER,
883: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
884: p_thpv_tbl IN thpv_tbl_type,
885: p_old_tlpv_tbl IN tlpv_tbl_type,
886: p_new_tlpv_tbl IN tlpv_tbl_type,
887: p_old_iipv_tbl IN iipv_tbl_type,
917: FROM dual;
918:
919:
920: BEGIN
921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
922:
923: --Call start_activity to create savepoint, check compatibility and initialize message list
924:
925: x_return_status := OKL_API.START_ACTIVITY(
921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
922:
923: --Call start_activity to create savepoint, check compatibility and initialize message list
924:
925: x_return_status := OKL_API.START_ACTIVITY(
926: l_api_name
927: ,p_init_msg_list
928: ,'_PUB'
929: ,x_return_status);
929: ,x_return_status);
930:
931: --Check if activity started successfully
932:
933: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_ERROR;
937: END IF;
930:
931: --Check if activity started successfully
932:
933: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_ERROR;
937: END IF;
938:
931: --Check if activity started successfully
932:
933: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_ERROR;
937: END IF;
938:
939: -- Create the Header Row
932:
933: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
934: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
935: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_ERROR;
937: END IF;
938:
939: -- Create the Header Row
940:
949: x_msg_data => x_msg_data,
950: p_thpv_tbl => l_thpv_tbl,
951: x_thpv_tbl => x_thpv_tbl);
952:
953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
956: RAISE OKL_API.G_EXCEPTION_ERROR;
957: END IF;
950: p_thpv_tbl => l_thpv_tbl,
951: x_thpv_tbl => x_thpv_tbl);
952:
953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
956: RAISE OKL_API.G_EXCEPTION_ERROR;
957: END IF;
958:
951: x_thpv_tbl => x_thpv_tbl);
952:
953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
956: RAISE OKL_API.G_EXCEPTION_ERROR;
957: END IF;
958:
959: --populate the TAS_Id to the old lines plsql table.
952:
953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
956: RAISE OKL_API.G_EXCEPTION_ERROR;
957: END IF;
958:
959: --populate the TAS_Id to the old lines plsql table.
960: l_old_tlpv_tbl(1).TAS_ID := x_thpv_tbl(1).ID;
979: x_msg_data => x_msg_data,
980: p_tlpv_tbl => l_old_tlpv_tbl,
981: x_tlpv_tbl => x_old_tlpv_tbl);
982:
983: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
985: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
986: RAISE OKL_API.G_EXCEPTION_ERROR;
987: END IF;
980: p_tlpv_tbl => l_old_tlpv_tbl,
981: x_tlpv_tbl => x_old_tlpv_tbl);
982:
983: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
985: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
986: RAISE OKL_API.G_EXCEPTION_ERROR;
987: END IF;
988:
981: x_tlpv_tbl => x_old_tlpv_tbl);
982:
983: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
985: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
986: RAISE OKL_API.G_EXCEPTION_ERROR;
987: END IF;
988:
989: --Change done for making serial number optional.
982:
983: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
985: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
986: RAISE OKL_API.G_EXCEPTION_ERROR;
987: END IF;
988:
989: --Change done for making serial number optional.
990: IF l_old_iipv_tbl(1).serial_number is not NULL THEN
1001: x_msg_data => x_msg_data,
1002: p_iipv_tbl => l_old_iipv_tbl,
1003: x_iipv_tbl => x_old_iipv_tbl);
1004:
1005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_ERROR;
1009: END IF;
1002: p_iipv_tbl => l_old_iipv_tbl,
1003: x_iipv_tbl => x_old_iipv_tbl);
1004:
1005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_ERROR;
1009: END IF;
1010:
1003: x_iipv_tbl => x_old_iipv_tbl);
1004:
1005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_ERROR;
1009: END IF;
1010:
1011: END IF;
1004:
1005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_ERROR;
1009: END IF;
1010:
1011: END IF;
1012: --populate the TAS_Id to the new lines plsql table.
1029: x_msg_data => x_msg_data,
1030: p_tlpv_tbl => l_new_tlpv_tbl,
1031: x_tlpv_tbl => x_new_tlpv_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_tlpv_tbl => l_new_tlpv_tbl,
1031: x_tlpv_tbl => x_new_tlpv_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_tlpv_tbl => x_new_tlpv_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:
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:
1040: --Change done for making serial number optional
1052: x_msg_data => x_msg_data,
1053: p_iipv_tbl => l_new_iipv_tbl,
1054: x_iipv_tbl => x_new_iipv_tbl);
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1053: p_iipv_tbl => l_new_iipv_tbl,
1054: x_iipv_tbl => x_new_iipv_tbl);
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1054: x_iipv_tbl => x_new_iipv_tbl);
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1062: END IF;
1055:
1056: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1062: END IF;
1063:
1060: END IF;
1061:
1062: END IF;
1063:
1064: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1065: EXCEPTION
1066: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: l_api_name,
1062: END IF;
1063:
1064: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1065: EXCEPTION
1066: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: l_api_name,
1069: G_PKG_NAME,
1070: 'OKL_API.G_RET_STS_ERROR',
1063:
1064: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1065: EXCEPTION
1066: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: l_api_name,
1069: G_PKG_NAME,
1070: 'OKL_API.G_RET_STS_ERROR',
1071: x_msg_count,
1066: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: l_api_name,
1069: G_PKG_NAME,
1070: 'OKL_API.G_RET_STS_ERROR',
1071: x_msg_count,
1072: x_msg_data,
1073: '_PUB');
1074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1070: 'OKL_API.G_RET_STS_ERROR',
1071: x_msg_count,
1072: x_msg_data,
1073: '_PUB');
1074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1076: l_api_name,
1077: G_PKG_NAME,
1078: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1071: x_msg_count,
1072: x_msg_data,
1073: '_PUB');
1074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1076: l_api_name,
1077: G_PKG_NAME,
1078: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1079: x_msg_count,
1074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1075: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1076: l_api_name,
1077: G_PKG_NAME,
1078: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1079: x_msg_count,
1080: x_msg_data,
1081: '_PUB');
1082: WHEN OTHERS THEN
1079: x_msg_count,
1080: x_msg_data,
1081: '_PUB');
1082: WHEN OTHERS THEN
1083: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1084: l_api_name,
1085: G_PKG_NAME,
1086: 'OTHERS',
1087: x_msg_count,
1097:
1098:
1099: PROCEDURE exchange(
1100: p_api_version IN NUMBER,
1101: p_init_msg_list IN VARCHAR2 := OKL_API.G_FALSE,
1102: p_tas_id IN NUMBER,
1103: x_return_status OUT NOCOPY VARCHAR2,
1104: x_msg_count OUT NOCOPY NUMBER,
1105: x_msg_data OUT NOCOPY VARCHAR2)
1167:
1168:
1169: BEGIN
1170:
1171: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1172:
1173: --Call start_activity to create savepoint, check compatibility and initialize message list
1174:
1175: x_return_status := OKL_API.START_ACTIVITY(
1171: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1172:
1173: --Call start_activity to create savepoint, check compatibility and initialize message list
1174:
1175: x_return_status := OKL_API.START_ACTIVITY(
1176: l_api_name
1177: ,p_init_msg_list
1178: ,'_PUB'
1179: ,x_return_status);
1179: ,x_return_status);
1180:
1181: --Check if activity started successfully
1182:
1183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1180:
1181: --Check if activity started successfully
1182:
1183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188:
1181: --Check if activity started successfully
1182:
1183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188:
1189: -- probably i might have to take the transaction id/request id and
1182:
1183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188:
1189: -- probably i might have to take the transaction id/request id and
1190: -- use it to get the relevant asset details for the new asset and then
1206: p_cvmv_rec => p_cvmv_rec,
1207: x_cvmv_rec => x_cvmv_rec,
1208: p_commit => 'T');
1209:
1210: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1207: x_cvmv_rec => x_cvmv_rec,
1208: p_commit => 'T');
1209:
1210: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215:
1208: p_commit => 'T');
1209:
1210: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215:
1216:
1209:
1210: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215:
1216:
1217: -- This piece of code is added to fix Bug 2477684
1236: p_asset_number => x_talv_tbl(1).asset_number,
1237: px_asset_desc => l_asset_desc,
1238: px_model_no => x_talv_tbl(1).model_number,
1239: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1243: RAISE OKL_API.G_EXCEPTION_ERROR;
1244: END IF;
1237: px_asset_desc => l_asset_desc,
1238: px_model_no => x_talv_tbl(1).model_number,
1239: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1243: RAISE OKL_API.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1238: px_model_no => x_talv_tbl(1).model_number,
1239: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1243: RAISE OKL_API.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1246:
1239: px_manufacturer => x_talv_tbl(1).manufacturer_name);
1240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1243: RAISE OKL_API.G_EXCEPTION_ERROR;
1244: END IF;
1245:
1246:
1247: OPEN c_asset_id1(x_talv_tbl(1).dnz_khr_id,x_talv_tbl(1).dnz_asset_id,x_talv_tbl(1).asset_number);
1260: p_dnz_chr_id => x_talv_tbl(1).dnz_khr_id,
1261: p_parent_line_id => l_id1_okx_asset_lines,
1262: p_year => x_talv_tbl(1).year_manufactured,
1263: x_year => x_year);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1261: p_parent_line_id => l_id1_okx_asset_lines,
1262: p_year => x_talv_tbl(1).year_manufactured,
1263: x_year => x_year);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: -- END IF;
1262: p_year => x_talv_tbl(1).year_manufactured,
1263: x_year => x_year);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: -- END IF;
1270:
1263: x_year => x_year);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: -- END IF;
1270:
1271:
1280: --akrangan bug 5362977 start
1281: --p_item_description => l_item_desc);
1282: p_item_description => l_asset_desc);
1283: --akrangan bug 5362977 end
1284: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1287: RAISE OKL_API.G_EXCEPTION_ERROR;
1288: END IF;
1281: --p_item_description => l_item_desc);
1282: p_item_description => l_asset_desc);
1283: --akrangan bug 5362977 end
1284: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1287: RAISE OKL_API.G_EXCEPTION_ERROR;
1288: END IF;
1289:
1282: p_item_description => l_asset_desc);
1283: --akrangan bug 5362977 end
1284: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1287: RAISE OKL_API.G_EXCEPTION_ERROR;
1288: END IF;
1289:
1290:
1283: --akrangan bug 5362977 end
1284: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1287: RAISE OKL_API.G_EXCEPTION_ERROR;
1288: END IF;
1289:
1290:
1291: --change for making sno optional
1304: x_return_status => x_return_status,
1305: x_msg_count => x_msg_count,
1306: x_msg_data => x_msg_data);
1307:
1308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_ERROR;
1312: END IF;
1305: x_msg_count => x_msg_count,
1306: x_msg_data => x_msg_data);
1307:
1308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_ERROR;
1312: END IF;
1313: end if; -- for p_no_data_found
1306: x_msg_data => x_msg_data);
1307:
1308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_ERROR;
1312: END IF;
1313: end if; -- for p_no_data_found
1314: ---------------------------------------------------------
1307:
1308: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1310: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_ERROR;
1312: END IF;
1313: end if; -- for p_no_data_found
1314: ---------------------------------------------------------
1315: OPEN c_model_line(x_talv_tbl(1).kle_id);
1342: x_cplv_rec => x_cplv_rec);
1343:
1344:
1345:
1346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1349: RAISE OKL_API.G_EXCEPTION_ERROR;
1350: END IF;
1343:
1344:
1345:
1346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1349: RAISE OKL_API.G_EXCEPTION_ERROR;
1350: END IF;
1351: ELSE
1344:
1345:
1346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1349: RAISE OKL_API.G_EXCEPTION_ERROR;
1350: END IF;
1351: ELSE
1352: NULL;
1345:
1346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1349: RAISE OKL_API.G_EXCEPTION_ERROR;
1350: END IF;
1351: ELSE
1352: NULL;
1353:
1356:
1357: -- update the transaction table and set the status to processed or whatever
1358: --If the trx failed then i have to record the reason for failure and send message to the
1359: --concerned person abt this. How do we do this?
1360: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1361: p_thpv_tbl(1).id := p_tas_id;
1362: p_thpv_tbl(1).tsu_code := 'PROCESSED';
1363: okl_trx_assets_pub.update_trx_ass_h_def(
1364: p_api_version => p_api_version,
1372:
1373:
1374:
1375: EXCEPTION
1376: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1378: l_api_name,
1379: G_PKG_NAME,
1380: 'OKL_API.G_RET_STS_ERROR',
1373:
1374:
1375: EXCEPTION
1376: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1378: l_api_name,
1379: G_PKG_NAME,
1380: 'OKL_API.G_RET_STS_ERROR',
1381: x_msg_count,
1376: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1378: l_api_name,
1379: G_PKG_NAME,
1380: 'OKL_API.G_RET_STS_ERROR',
1381: x_msg_count,
1382: x_msg_data,
1383: '_PUB');
1384: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1380: 'OKL_API.G_RET_STS_ERROR',
1381: x_msg_count,
1382: x_msg_data,
1383: '_PUB');
1384: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1385: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1386: l_api_name,
1387: G_PKG_NAME,
1388: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1381: x_msg_count,
1382: x_msg_data,
1383: '_PUB');
1384: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1385: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1386: l_api_name,
1387: G_PKG_NAME,
1388: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1389: x_msg_count,
1384: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1385: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1386: l_api_name,
1387: G_PKG_NAME,
1388: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1389: x_msg_count,
1390: x_msg_data,
1391: '_PUB');
1392: WHEN OTHERS THEN
1389: x_msg_count,
1390: x_msg_data,
1391: '_PUB');
1392: WHEN OTHERS THEN
1393: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1394: l_api_name,
1395: G_PKG_NAME,
1396: 'OTHERS',
1397: x_msg_count,