DBA Data[Home] [Help]

APPS.OKL_SO_CREDIT_APP_WF dependencies on OKL_API

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

83: END IF;
84: EXCEPTION
85:
86: WHEN OTHERS THEN
87: FND_MESSAGE.SET_NAME('OKL', 'OKL_API_OTHERS_EXCEP');
88: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
89: FND_MSG_PUB.ADD;
90: ROLLBACK TO create_credit_app_event;
91: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR ;

Line 600: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

596:
597: x_msg_data VARCHAR2(2000);
598: x_msg_count NUMBER := 0 ;
599: l_api_version NUMBER := 1 ;
600: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
601:
602: l_inv_org_id NUMBER;
603:
604: CURSOR l_okl_lse_id IS

Line 958: p_init_msg_list => okl_api.g_true,

954: --l_interaction_rec.object_type := null;
955:
956: jtf_ih_pub.open_interaction(
957: p_api_version => l_api_version,
958: p_init_msg_list => okl_api.g_true,
959: p_commit => okl_api.g_false,
960: p_user_id => l_user_id,
961: p_login_id => l_login_id,
962: x_return_status => x_return_status,

Line 959: p_commit => okl_api.g_false,

955:
956: jtf_ih_pub.open_interaction(
957: p_api_version => l_api_version,
958: p_init_msg_list => okl_api.g_true,
959: p_commit => okl_api.g_false,
960: p_user_id => l_user_id,
961: p_login_id => l_login_id,
962: x_return_status => x_return_status,
963: x_msg_count => x_msg_count,

Line 1003: p_init_msg_list => okl_api.g_true,

999: --l_activity_rec.source_code := null;
1000:
1001: jtf_ih_pub.add_activity(
1002: p_api_version => l_api_version,
1003: p_init_msg_list => okl_api.g_true,
1004: p_commit => okl_api.g_false,
1005: p_user_id => l_user_id,
1006: p_login_id => l_login_id,
1007: x_return_status => x_return_status,

Line 1004: p_commit => okl_api.g_false,

1000:
1001: jtf_ih_pub.add_activity(
1002: p_api_version => l_api_version,
1003: p_init_msg_list => okl_api.g_true,
1004: p_commit => okl_api.g_false,
1005: p_user_id => l_user_id,
1006: p_login_id => l_login_id,
1007: x_return_status => x_return_status,
1008: x_msg_count => x_msg_count,

Line 1023: p_init_msg_list => okl_api.g_true,

1019: END IF;
1020:
1021: jtf_ih_pub.CLOSE_INTERACTION (
1022: p_api_version => l_api_version,
1023: p_init_msg_list => okl_api.g_true,
1024: p_commit => okl_api.g_false,
1025: P_RESP_APPL_ID => l_resp_appl_id,
1026: P_RESP_ID => l_resp_id,
1027: P_USER_ID => l_user_id,

Line 1024: p_commit => okl_api.g_false,

1020:
1021: jtf_ih_pub.CLOSE_INTERACTION (
1022: p_api_version => l_api_version,
1023: p_init_msg_list => okl_api.g_true,
1024: p_commit => okl_api.g_false,
1025: P_RESP_APPL_ID => l_resp_appl_id,
1026: P_RESP_ID => l_resp_id,
1027: P_USER_ID => l_user_id,
1028: P_LOGIN_ID => l_login_id,

Line 1171: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1167: x_lapv_rec lapv_rec_type;
1168: l_exp_date DATE;
1169:
1170: BEGIN
1171: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1172: L_MODULE := 'OKL.PLSQL.OKL_SO_CREDIT_APP_WF.UPDATE_STATUS';
1173:
1174: -- check for logging on PROCEDURE level
1175: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');

Line 1252: ,p_init_msg_list => OKL_API.G_FALSE

1248:
1249: -- call the procedure to create lease quote line
1250: OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE(
1251: p_api_version => l_api_version
1252: ,p_init_msg_list => OKL_API.G_FALSE
1253: ,p_transaction_control => OKL_API.G_TRUE
1254: ,p_lease_qte_rec => l_lsqv_rec
1255: ,x_lease_qte_rec => x_lsqv_rec
1256: ,x_return_status => l_return_status

Line 1253: ,p_transaction_control => OKL_API.G_TRUE

1249: -- call the procedure to create lease quote line
1250: OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE(
1251: p_api_version => l_api_version
1252: ,p_init_msg_list => OKL_API.G_FALSE
1253: ,p_transaction_control => OKL_API.G_TRUE
1254: ,p_lease_qte_rec => l_lsqv_rec
1255: ,x_lease_qte_rec => x_lsqv_rec
1256: ,x_return_status => l_return_status
1257: ,x_msg_count => x_msg_count

Line 1269: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

1265: ,'end debug call OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE');
1266: END IF;
1267:
1268:
1269: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1271: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: END IF;

Line 1270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1266: END IF;
1267:
1268:
1269: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1271: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: END IF;
1274:

Line 1271: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN

1267:
1268:
1269: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1271: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: END IF;
1274:
1275: END IF;

Line 1272: RAISE OKL_API.G_EXCEPTION_ERROR;

1268:
1269: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1271: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1272: RAISE OKL_API.G_EXCEPTION_ERROR;
1273: END IF;
1274:
1275: END IF;
1276:

Line 1294: ,p_init_msg_list => OKL_API.G_FALSE

1290: END IF;
1291:
1292: OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS(
1293: p_api_version => l_api_version
1294: ,p_init_msg_list => OKL_API.G_FALSE
1295: ,p_lap_id => l_lap_id
1296: ,p_lap_status => l_lap_status
1297: ,x_return_status => l_return_status
1298: ,x_msg_count => x_msg_count

Line 1329: if (l_exp_date is not null and l_exp_date <> OKL_API.G_MISS_DATE) then

1325: END IF;
1326:
1327: -- Added for bug 7375141 - start
1328: l_exp_date := OKL_LEASE_APP_PVT.get_approval_exp_date(l_lap_id);
1329: if (l_exp_date is not null and l_exp_date <> OKL_API.G_MISS_DATE) then
1330: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
1331: THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(
1333: FND_LOG.LEVEL_PROCEDURE

Line 1340: ,p_init_msg_list => OKL_API.G_FALSE

1336: END IF;
1337:
1338: OKL_LEASE_APP_PVT.POPULATE_LEASE_APP(
1339: p_api_version => l_api_version
1340: ,p_init_msg_list => OKL_API.G_FALSE
1341: ,x_return_status => l_return_status
1342: ,x_msg_count => x_msg_count
1343: ,x_msg_data => x_msg_data
1344: ,p_lap_id => l_lap_id

Line 1385: ,p_init_msg_list => OKL_API.G_FALSE

1381: END IF;
1382:
1383: OKL_LAP_PVT.UPDATE_ROW(
1384: p_api_version => l_api_version
1385: ,p_init_msg_list => OKL_API.G_FALSE
1386: ,x_return_status => l_return_status
1387: ,x_msg_count => x_msg_count
1388: ,x_msg_data => x_msg_data
1389: ,p_lapv_rec => l_lapv_rec

Line 1432: ,p_init_msg_list => OKL_API.G_FALSE

1428: END IF;
1429:
1430: OKL_LEASE_APP_PVT.REVERT_TO_ORIG_STATUS(
1431: p_api_version => l_api_version
1432: ,p_init_msg_list => OKL_API.G_FALSE
1433: ,p_lap_id => l_lap_id
1434: ,x_return_status => l_return_status
1435: ,x_msg_count => x_msg_count
1436: ,x_msg_data => x_msg_data);

Line 1472: ,p_init_msg_list => OKL_API.G_FALSE

1468: ,l_lap_id
1469: ,l_parameter_list);
1470:
1471: okl_wf_pvt.raise_event(p_api_version => l_api_version
1472: ,p_init_msg_list => OKL_API.G_FALSE
1473: ,x_return_status => l_return_status
1474: ,x_msg_count => x_msg_count
1475: ,x_msg_data => x_msg_data
1476: ,p_event_name => p_event_name