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 917: p_init_msg_list => OKL_API.G_FALSE,

913: l_loc_rec.date_from := l_trx_date;
914:
915: OKL_BLK_AST_UPD_PUB.update_location(
916: p_api_version => 1.0,
917: p_init_msg_list => OKL_API.G_FALSE,
918: p_loc_rec => l_loc_rec,
919: x_return_status => x_return_status,
920: x_msg_count => x_msg_count,
921: x_msg_data => l_msg_data);

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

1163: x_return_status => x_return_status,
1164: x_msg_count => x_msg_count,
1165: x_msg_data => x_msg_data);
1166:
1167: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;

Line 1168: RAISE OKL_API.G_EXCEPTION_ERROR;

1164: x_msg_count => x_msg_count,
1165: x_msg_data => x_msg_data);
1166:
1167: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172: end loop;

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

1165: x_msg_data => x_msg_data);
1166:
1167: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172: end loop;
1173:

Line 1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1166:
1167: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1168: RAISE OKL_API.G_EXCEPTION_ERROR;
1169: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: END IF;
1172: end loop;
1173:
1174: EXCEPTION

Line 1176: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1172: end loop;
1173:
1174: EXCEPTION
1175:
1176: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1177: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:

Line 1177: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1173:
1174: EXCEPTION
1175:
1176: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1177: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1177: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1183: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:

Line 1182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1178: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1183: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: WHEN OTHERS THEN

Line 1187: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1183: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: WHEN OTHERS THEN
1187: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1188: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Serial_Number');
1189: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1190: p_data => x_msg_data);
1191:

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

1312: x_return_status => x_return_status,
1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315:
1316: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: END IF;

Line 1317: RAISE OKL_API.G_EXCEPTION_ERROR;

1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315:
1316: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: END IF;
1321:

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

1314: x_msg_data => x_msg_data);
1315:
1316: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: END IF;
1321:
1322: end loop;

Line 1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1315:
1316: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1317: RAISE OKL_API.G_EXCEPTION_ERROR;
1318: ELSIF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1320: END IF;
1321:
1322: end loop;
1323:

Line 1326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1322: end loop;
1323:
1324: EXCEPTION
1325:
1326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:

Line 1327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1323:
1324: EXCEPTION
1325:
1326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:
1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:
1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1332: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1333: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1334: p_data => x_msg_data);
1335:

Line 1332: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1328: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:
1331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1332: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1333: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1334: p_data => x_msg_data);
1335:
1336: WHEN OTHERS THEN

Line 1337: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1333: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1334: p_data => x_msg_data);
1335:
1336: WHEN OTHERS THEN
1337: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','Update_Location');
1339: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:

Line 2363: ,p_restricted_update => OKL_API.G_FALSE

2359: ,p_init_msg_list => 'T'
2360: ,x_return_status => l_return_status
2361: ,x_msg_count => l_msg_count
2362: ,x_msg_data => l_msg_data
2363: ,p_restricted_update => OKL_API.G_FALSE
2364: ,p_chrv_rec => l_chrv_rec
2365: ,p_khrv_rec => l_khrv_rec
2366: ,x_chrv_rec => x_chrv_rec
2367: ,x_khrv_rec => x_khrv_rec);

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

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

Line 2989: OKL_API.G_FALSE,

2985: p_trqv_rec.currency_code := l_currency_code;
2986:
2987: --OKL_CS_LEASE_RENEWAL_PUB.update_trx_request(
2988: OKL_CS_LEASE_RENEWAL_PUB.update_lrnw_request(1.0,
2989: OKL_API.G_FALSE,
2990: x_return_status,
2991: x_msg_count,
2992: x_msg_data,
2993: p_trqv_rec,

Line 3086: OKL_API.G_FALSE,

3082: p_trqv_rec.currency_code := l_currency_code;
3083:
3084: --OKL_CS_LEASE_RENEWAL_PUB.update_trx_request(
3085: OKL_CS_LEASE_RENEWAL_PUB.update_lrnw_request(1.0,
3086: OKL_API.G_FALSE,
3087: x_return_status,
3088: x_msg_count,
3089: x_msg_data,
3090: p_trqv_rec,

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

3279: -- End - Make Payment - varangan
3280:
3281: -- Call to OKL_PAYMENT_PUB.CREATEPAYMENTS From OKL_SSC_WF End
3282:
3283: xl_return_status := nvl(xl_return_status,OKL_API.G_RET_STS_UNEXP_ERROR);
3284:
3285: IF(IS_DEBUG_PROCEDURE_ON) THEN
3286: BEGIN
3287: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLSSWFB.pls call OKL_PAYMENT_PUB.CREATE_PAYMENTS ');

Line 3292: IF xl_return_status <> OKL_API.G_RET_STS_SUCCESS then

3288: END;
3289: END IF;
3290: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.get_rec
3291: -- check for errors
3292: IF xl_return_status <> OKL_API.G_RET_STS_SUCCESS then
3293: xl_msg_data := 'OKL_PAYMENT_CREATE_FAILED';
3294: RAISE make_payment_error;
3295:
3296: END IF;

Line 3311: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3307: return;
3308:
3309: EXCEPTION
3310: when make_payment_error then
3311: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3312: END make_payment_wrapper_wf;
3313:
3314:
3315: --Make Payment Event function to set attributes

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

3439: l_qtev_rec qtev_rec_type;
3440: l_qpyv_tbl qpyv_tbl_type;
3441: l_q_party_uv_tbl q_party_uv_tbl_type;
3442: l_record_count NUMBER;
3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3444: l_recipient_exist_flag VARCHAR2(1) :='N';
3445: l_api_version CONSTANT NUMBER := 1.0;
3446: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
3447: l_msg_data VARCHAR2(2000);

Line 3446: l_msg_count NUMBER := OKL_API.G_MISS_NUM;

3442: l_record_count NUMBER;
3443: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3444: l_recipient_exist_flag VARCHAR2(1) :='N';
3445: l_api_version CONSTANT NUMBER := 1.0;
3446: l_msg_count NUMBER := OKL_API.G_MISS_NUM;
3447: l_msg_data VARCHAR2(2000);
3448: i NUMBER;
3449: api_exception EXCEPTION;
3450: --Fixed Bug # 5484903

Line 3755: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

3751: ,p_parameters => l_parameter_list);
3752:
3753: exception
3754: WHEN OTHERS THEN
3755: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3756: (
3757: l_api_name,
3758: G_PKG_NAME,
3759: 'OTHERS',