DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SSC_WF';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8: L_MODULE VARCHAR2(40) := 'LEASE.SETUP.FUNCTIONS';
9: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
10: L_LEVEL_PROCEDURE NUMBER;
11: IS_DEBUG_PROCEDURE_ON BOOLEAN;

Line 985: p_init_msg_list => OKL_API.G_FALSE,

981: l_loc_rec.date_from := l_trx_date;
982:
983: OKL_BLK_AST_UPD_PUB.update_location(
984: p_api_version => 1.0,
985: p_init_msg_list => OKL_API.G_FALSE,
986: p_loc_rec => l_loc_rec,
987: x_return_status => x_return_status,
988: x_msg_count => x_msg_count,
989: x_msg_data => l_msg_data);

Line 1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1249: x_return_status => x_return_status,
1250: x_msg_count => x_msg_count,
1251: x_msg_data => x_msg_data);
1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: END IF;

Line 1254: RAISE OKL_API.G_EXCEPTION_ERROR;

1250: x_msg_count => x_msg_count,
1251: x_msg_data => x_msg_data);
1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: END IF;
1258: end loop;

Line 1255: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1251: x_msg_data => x_msg_data);
1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: END IF;
1258: end loop;
1259:

Line 1256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1257: END IF;
1258: end loop;
1259:
1260: EXCEPTION

Line 1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1258: end loop;
1259:
1260: EXCEPTION
1261:
1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1263: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1264: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:

Line 1263: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1259:
1260: EXCEPTION
1261:
1262: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1263: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1264: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1263: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1264: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1270: p_data => x_msg_data);
1271:

Line 1268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1264: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1268: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1270: p_data => x_msg_data);
1271:
1272: WHEN OTHERS THEN

Line 1273: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1269: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1270: p_data => x_msg_data);
1271:
1272: WHEN OTHERS THEN
1273: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1274: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1275: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1276: p_data => x_msg_data);
1277:

Line 1402: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1398: x_return_status => x_return_status,
1399: x_msg_count => x_msg_count,
1400: x_msg_data => x_msg_data);
1401:
1402: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1403: RAISE OKL_API.G_EXCEPTION_ERROR;
1404: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;

Line 1403: RAISE OKL_API.G_EXCEPTION_ERROR;

1399: x_msg_count => x_msg_count,
1400: x_msg_data => x_msg_data);
1401:
1402: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1403: RAISE OKL_API.G_EXCEPTION_ERROR;
1404: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;
1407:

Line 1404: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1400: x_msg_data => x_msg_data);
1401:
1402: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1403: RAISE OKL_API.G_EXCEPTION_ERROR;
1404: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;
1407:
1408: end loop;

Line 1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1401:
1402: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1403: RAISE OKL_API.G_EXCEPTION_ERROR;
1404: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;
1407:
1408: end loop;
1409:

Line 1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1408: end loop;
1409:
1410: EXCEPTION
1411:
1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416:

Line 1413: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1409:
1410: EXCEPTION
1411:
1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1413: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416:
1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1413: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1414: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416:
1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1419: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1420: p_data => x_msg_data);
1421:

Line 1418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1414: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1415: p_data => x_msg_data);
1416:
1417: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1419: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1420: p_data => x_msg_data);
1421:
1422: WHEN OTHERS THEN

Line 1423: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1419: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1420: p_data => x_msg_data);
1421:
1422: WHEN OTHERS THEN
1423: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1424: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1425: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1426: p_data => x_msg_data);
1427:

Line 2449: ,p_restricted_update => OKL_API.G_FALSE

2445: ,p_init_msg_list => 'T'
2446: ,x_return_status => l_return_status
2447: ,x_msg_count => l_msg_count
2448: ,x_msg_data => l_msg_data
2449: ,p_restricted_update => OKL_API.G_FALSE
2450: ,p_chrv_rec => l_chrv_rec
2451: ,p_khrv_rec => l_khrv_rec
2452: ,x_chrv_rec => x_chrv_rec
2453: ,x_khrv_rec => x_khrv_rec);

Line 2992: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');

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');
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 ;

Line 3075: OKL_API.G_FALSE,

3071: p_trqv_rec.currency_code := l_currency_code;
3072:
3073: --OKL_CS_LEASE_RENEWAL_PUB.update_trx_request(
3074: OKL_CS_LEASE_RENEWAL_PUB.update_lrnw_request(1.0,
3075: OKL_API.G_FALSE,
3076: x_return_status,
3077: x_msg_count,
3078: x_msg_data,
3079: p_trqv_rec,

Line 3172: OKL_API.G_FALSE,

3168: p_trqv_rec.currency_code := l_currency_code;
3169:
3170: --OKL_CS_LEASE_RENEWAL_PUB.update_trx_request(
3171: OKL_CS_LEASE_RENEWAL_PUB.update_lrnw_request(1.0,
3172: OKL_API.G_FALSE,
3173: x_return_status,
3174: x_msg_count,
3175: x_msg_data,
3176: p_trqv_rec,

Line 3369: xl_return_status := nvl(xl_return_status,OKL_API.G_RET_STS_UNEXP_ERROR);

3365: -- End - Make Payment - varangan
3366:
3367: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF End
3368:
3369: xl_return_status := nvl(xl_return_status,OKL_API.G_RET_STS_UNEXP_ERROR);
3370:
3371: IF(IS_DEBUG_PROCEDURE_ON) THEN
3372: BEGIN
3373: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLSSWFB.pls call OKL_PAYMENT_PUB.CREATE_PAYMENTS ');

Line 3378: IF xl_return_status <> OKL_API.G_RET_STS_SUCCESS then

3374: END;
3375: END IF;
3376: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.get_rec
3377: -- check for errors
3378: IF xl_return_status <> OKL_API.G_RET_STS_SUCCESS then
3379: xl_msg_data := 'OKL_PAYMENT_CREATE_FAILED';
3380: RAISE make_payment_error;
3381:
3382: END IF;

Line 3397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3393: return;
3394:
3395: EXCEPTION
3396: when make_payment_error then
3397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3398: END make_payment_wrapper_wf;
3399:
3400:
3401: --Make Payment Event function to set attributes

Line 3529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3525: l_qtev_rec qtev_rec_type;
3526: l_qpyv_tbl qpyv_tbl_type;
3527: l_q_party_uv_tbl q_party_uv_tbl_type;
3528: l_record_count NUMBER;
3529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3530: l_recipient_exist_flag VARCHAR2(1) :='N';
3531: l_api_version CONSTANT NUMBER := 1.0;
3532: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
3533: l_msg_data VARCHAR2(2000);

Line 3532: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

3528: l_record_count NUMBER;
3529: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3530: l_recipient_exist_flag VARCHAR2(1) :='N';
3531: l_api_version CONSTANT NUMBER := 1.0;
3532: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
3533: l_msg_data VARCHAR2(2000);
3534: i NUMBER;
3535: api_exception EXCEPTION;
3536: --Fixed Bug # 5484903

Line 3841: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

3837: ,p_parameters => l_parameter_list);
3838:
3839: exception
3840: WHEN OTHERS THEN
3841: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3842: (
3843: l_api_name,
3844: G_PKG_NAME,
3845: 'OTHERS',