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 995: p_init_msg_list => OKC_API.G_FALSE,

991: l_tas_id := to_number(WF_ENGINE.GetItemAttrText(itemtype,itemkey,'SSCTASID'));
992:
993:
994: update_location(p_api_version => 1.0,
995: p_init_msg_list => OKC_API.G_FALSE,
996: p_tas_id => l_tas_id,
997: x_return_status => x_return_status,
998: x_msg_count => x_msg_count,
999: x_msg_data => l_msg_data);

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

1085: p_cle_id IN NUMBER,
1086: p_transaction_type IN VARCHAR2,
1087: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
1088:
1089: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1090: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
1091: l_api_version CONSTANT NUMBER := 1.0;
1092:
1093: --Following cursor assumes that a transaction type called

Line 1106: Raise OKC_API.G_EXCEPTION_ERROR;

1102: Fetch okl_trx_type_curs
1103: into l_trx_type_id;
1104: If okl_trx_type_curs%NotFound Then
1105: --OKL LINE ACTIVATION not seeded as a source transaction in IB
1106: Raise OKC_API.G_EXCEPTION_ERROR;
1107: End If;
1108: close okl_trx_type_curs;
1109: --Assign transaction Type id to seeded value in cs_lookups
1110: x_trx_rec.transaction_type_id := l_trx_type_id;

Line 1116: When OKC_API.G_EXCEPTION_ERROR Then

1112: x_trx_rec.source_line_ref_id := p_cle_id;
1113: x_trx_rec.transaction_date := sysdate;
1114: x_trx_rec.source_transaction_date := sysdate;
1115: Exception
1116: When OKC_API.G_EXCEPTION_ERROR Then
1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,

Line 1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1113: x_trx_rec.transaction_date := sysdate;
1114: x_trx_rec.source_transaction_date := sysdate;
1115: Exception
1116: When OKC_API.G_EXCEPTION_ERROR Then
1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'OKC_API.G_RET_STS_ERROR',

Line 1121: 'OKC_API.G_RET_STS_ERROR',

1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'OKC_API.G_RET_STS_ERROR',
1122: x_msg_count,
1123: x_msg_data,
1124: '_PUB'
1125: );

Line 1126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1122: x_msg_count,
1123: x_msg_data,
1124: '_PUB'
1125: );
1126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,

Line 1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1123: x_msg_data,
1124: '_PUB'
1125: );
1126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1131: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1132: x_msg_count,
1133: x_msg_data,
1134: '_PUB'
1135: );

Line 1137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1133: x_msg_data,
1134: '_PUB'
1135: );
1136: WHEN OTHERS THEN
1137: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'OTHERS',

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

2160: l_rule_tbl(l_counter).dnz_chr_id := l_contract_id;
2161: l_rule_tbl(l_counter).sfwt_flag := 'N';
2162: l_rule_tbl(l_counter).std_template_yn := 'N';
2163: l_rule_tbl(l_counter).warn_yn := 'N';
2164: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2165: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2166: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2167: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2168: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;

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

2161: l_rule_tbl(l_counter).sfwt_flag := 'N';
2162: l_rule_tbl(l_counter).std_template_yn := 'N';
2163: l_rule_tbl(l_counter).warn_yn := 'N';
2164: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2165: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2166: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2167: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2168: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2169: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';

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

2162: l_rule_tbl(l_counter).std_template_yn := 'N';
2163: l_rule_tbl(l_counter).warn_yn := 'N';
2164: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2165: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2166: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2167: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2168: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2169: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2170: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;

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

2163: l_rule_tbl(l_counter).warn_yn := 'N';
2164: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2165: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2166: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2167: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2168: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2169: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2170: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;
2171:

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

2164: l_rule_tbl(l_counter).created_by := OKC_API.G_MISS_NUM;
2165: l_rule_tbl(l_counter).CREATION_DATE := OKC_API.G_MISS_DATE;
2166: l_rule_tbl(l_counter).LAST_UPDATED_BY := OKC_API.G_MISS_NUM;
2167: l_rule_tbl(l_counter).LAST_UPDATE_DATE := OKC_API.G_MISS_DATE;
2168: l_rule_tbl(l_counter).LAST_UPDATE_LOGIN := OKC_API.G_MISS_NUM;
2169: l_rule_tbl(l_counter).rule_information_category := 'LAINVD';
2170: l_rule_tbl(l_counter).rule_information1 := l_invoice_format;
2171:
2172: OKL_RGRP_RULES_PROCESS_PUB.process_rule_group_rules(

Line 2751: l_return_status := OKC_API.G_RET_STS_SUCCESS ;

2747: begin
2748:
2749: SAVEPOINT cancel_insurance;
2750:
2751: l_return_status := OKC_API.G_RET_STS_SUCCESS ;
2752: -- Test if there are any active subscritions
2753: -- if it is the case then execute the subscriptions
2754: l_yn := exist_subscription(l_event_name);
2755:

Line 2806: l_return_status := OKC_API.G_RET_STS_ERROR ;

2802:
2803: ELSE
2804: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2805: FND_MSG_PUB.ADD;
2806: l_return_status := OKC_API.G_RET_STS_ERROR ;
2807:
2808: x_return_status := l_return_status ;
2809: x_msg_count := l_msg_count ;
2810: x_msg_data := l_msg_data ;

Line 2962: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;

2958: BEGIN
2959:
2960: SAVEPOINT create_claim_event;
2961:
2962: x_retrun_status := OKC_API.G_RET_STS_SUCCESS ;
2963: -- Test if there are any active subscritions
2964: -- if it is the case then execute the subscriptions
2965: l_yn := exist_subscription(l_event_name);
2966: IF l_yn = 'Y' THEN

Line 2988: x_retrun_status := OKC_API.G_RET_STS_ERROR ;

2984:
2985: ELSE
2986: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
2987: FND_MSG_PUB.ADD;
2988: x_retrun_status := OKC_API.G_RET_STS_ERROR ;
2989: END IF;
2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

Line 2996: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

2992: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
2993: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2994: FND_MSG_PUB.ADD;
2995: ROLLBACK TO create_claim_event;
2996: x_retrun_status := OKC_API.G_RET_STS_UNEXP_ERROR ;
2997:
2998: END create_claim_event;
2999:
3000: -- Start of comments

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

3244: -- End - Payments Uptake
3245: )
3246: IS
3247: -------------------------------------------------------------------------------------
3248: pl_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
3249: xl_return_status VARCHAR2(1) := 'U';
3250: xl_msg_count NUMBER;
3251: xl_msg_data VARCHAR2(2000);
3252: pl_cons_bill_id NUMBER;

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

3631: x_msg_count OUT NOCOPY NUMBER,
3632: x_msg_data OUT NOCOPY VARCHAR2)
3633: IS
3634: l_yn VARCHAR2(1);
3635: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3636: l_event_name varchar2(240) := 'oracle.apps.okl.ssc.createterminationquote';
3637: l_msg_count NUMBER ;
3638: l_msg_data VARCHAR2(2000);
3639: l_message VARCHAR2(2000);

Line 3650: l_return_status := OKC_API.G_RET_STS_ERROR;

3646:
3647: IF l_yn = 'N' THEN
3648: FND_MESSAGE.SET_NAME('OKL', 'OKL_NO_EVENT');
3649: FND_MSG_PUB.ADD;
3650: l_return_status := OKC_API.G_RET_STS_ERROR;
3651: raise api_exception;
3652: ELSE
3653: WF_EVENT.raise2(l_event_name,
3654: l_event_name||l_seq,