eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SSC_WF dependencies on OKC_API

Line 524: p_init_msg_list => OKC_API.G_FALSE,

520:
521: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));
522:
523: update_serial_number(p_api_version => 1.0,
524: p_init_msg_list => OKC_API.G_FALSE,
525: p_tas_id => l_tas_id,
526: x_return_status => x_return_status,
527: x_msg_count => x_msg_count,
528: x_msg_data => l_msg_data);

Line 927: p_init_msg_list => OKC_API.G_FALSE,

923: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));
924:
925:
926: update_location(p_api_version => 1.0,
927: p_init_msg_list => OKC_API.G_FALSE,
928: p_tas_id => l_tas_id,
929: x_return_status => x_return_status,
930: x_msg_count => x_msg_count,
931: x_msg_data => l_msg_data);

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

999: p_cle_id IN NUMBER,
1000: p_transaction_type IN VARCHAR2,
1001: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
1002:
1003: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1004: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
1005: l_api_version CONSTANT NUMBER := 1.0;
1006:
1007: --Following cursor assumes that a transaction type called

Line 1020: Raise OKC_API.G_EXCEPTION_ERROR;

1016: Fetch okl_trx_type_curs
1017: into l_trx_type_id;
1018: If okl_trx_type_curs%NotFound Then
1019: --OKL LINE ACTIVATION not seeded as a source transaction in IB
1020: Raise OKC_API.G_EXCEPTION_ERROR;
1021: End If;
1022: close okl_trx_type_curs;
1023: --Assign transaction Type id to seeded value in cs_lookups
1024: x_trx_rec.transaction_type_id := l_trx_type_id;

Line 1030: When OKC_API.G_EXCEPTION_ERROR Then

1026: x_trx_rec.source_line_ref_id := p_cle_id;
1027: x_trx_rec.transaction_date := sysdate;
1028: x_trx_rec.source_transaction_date := sysdate;
1029: Exception
1030: When OKC_API.G_EXCEPTION_ERROR Then
1031: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,

Line 1031: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1027: x_trx_rec.transaction_date := sysdate;
1028: x_trx_rec.source_transaction_date := sysdate;
1029: Exception
1030: When OKC_API.G_EXCEPTION_ERROR Then
1031: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'OKC_API.G_RET_STS_ERROR',

Line 1035: 'OKC_API.G_RET_STS_ERROR',

1031: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'OKC_API.G_RET_STS_ERROR',
1036: x_msg_count,
1037: x_msg_data,
1038: '_PUB'
1039: );

Line 1040: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1036: x_msg_count,
1037: x_msg_data,
1038: '_PUB'
1039: );
1040: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,

Line 1041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1037: x_msg_data,
1038: '_PUB'
1039: );
1040: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1045: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1041: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1046: x_msg_count,
1047: x_msg_data,
1048: '_PUB'
1049: );

Line 1051: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1047: x_msg_data,
1048: '_PUB'
1049: );
1050: WHEN OTHERS THEN
1051: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1052: (
1053: l_api_name,
1054: G_PKG_NAME,
1055: 'OTHERS',

Line 2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;

2074: l_rule_tbl(l_counter).dnz_chr_id := l_contract_id;
2075: l_rule_tbl(l_counter).sfwt_flag := 'N';
2076: l_rule_tbl(l_counter).std_template_yn := 'N';
2077: l_rule_tbl(l_counter).warn_yn := 'N';
2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;

Line 2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;

2075: l_rule_tbl(l_counter).sfwt_flag := 'N';
2076: l_rule_tbl(l_counter).std_template_yn := 'N';
2077: l_rule_tbl(l_counter).warn_yn := 'N';
2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2083: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';

Line 2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;

2076: l_rule_tbl(l_counter).std_template_yn := 'N';
2077: l_rule_tbl(l_counter).warn_yn := 'N';
2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2083: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2084: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;

Line 2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;

2077: l_rule_tbl(l_counter).warn_yn := 'N';
2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2083: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2084: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;
2085:

Line 2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;

2078: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2079: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2080: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2081: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2082: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2083: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2084: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;
2085:
2086: OKL_RGRP_RULES_PROCESS_PUB.process_rule_group_rules(

Line 2665: l_return_status := OKC_API.G_RET_STS_SUCCESS ;

2661: begin
2662:
2663: SAVEPOINT cancel_insurance;
2664:
2665: l_return_status := OKC_API.G_RET_STS_SUCCESS ;
2666: -- Test if there are any active subscritions
2667: -- if it is the case then execute the subscriptions
2668: l_yn := exist_subscription(l_event_name);
2669:

Line 2720: l_return_status := OKC_API.G_RET_STS_ERROR ;

2716:
2717: ELSE
2718: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2719: FND_MSG_PUB.ADD;
2720: l_return_status := OKC_API.G_RET_STS_ERROR ;
2721:
2722: x_return_status := l_return_status ;
2723: x_msg_count := l_msg_count ;
2724: x_msg_data := l_msg_data ;

Line 2876: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;

2872: BEGIN
2873:
2874: SAVEPOINT create_claim_event;
2875:
2876: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;
2877: -- Test if there are any active subscritions
2878: -- if it is the case then execute the subscriptions
2879: l_yn := exist_subscription(l_event_name);
2880: IF l_yn = 'Y' THEN

Line 2902: x_retrun_status := OKC_API.G_RET_STS_ERROR ;

2898:
2899: ELSE
2900: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2901: FND_MSG_PUB.ADD;
2902: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
2903: END IF;
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

Line 2910: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

2906: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
2907: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2908: FND_MSG_PUB.ADD;
2909: ROLLBACK TO create_claim_event;
2910: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2911:
2912: END create_claim_event;
2913:
2914: -- Start of comments

Line 3162: pl_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

3158: -- End - Payments Uptake
3159: )
3160: IS
3161: -------------------------------------------------------------------------------------
3162: pl_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
3163: xl_return_status VARCHAR2(1) := 'U';
3164: xl_msg_count NUMBER;
3165: xl_msg_data VARCHAR2(2000);
3166: pl_cons_bill_id NUMBER;

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

3545: x_msg_count OUT NOCOPY NUMBER,
3546: x_msg_data OUT NOCOPY VARCHAR2)
3547: IS
3548: l_yn VARCHAR2(1);
3549: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3550: l_event_name varchar2(240) := 'oracle.apps.okl.ssc.createterminationquote';
3551: l_msg_count NUMBER ;
3552: l_msg_data VARCHAR2(2000);
3553: l_message VARCHAR2(2000);

Line 3564: l_return_status := OKC_API.G_RET_STS_ERROR;

3560:
3561: IF l_yn = 'N' THEN
3562: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3563: FND_MSG_PUB.ADD;
3564: l_return_status := OKC_API.G_RET_STS_ERROR;
3565: raise api_exception;
3566: ELSE
3567: WF_EVENT.raise2(l_event_name,
3568: l_event_name||l_seq,