DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKC_API

Line 1459: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,

1455:
1456: -- Check if quote id passed is valid
1457: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1458:
1459: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1460: p_msg_name => OKC_API.G_INVALID_VALUE,
1461: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1462: p_token1_value => 'Quote id');
1463:

Line 1460: p_msg_name => OKC_API.G_INVALID_VALUE,

1456: -- Check if quote id passed is valid
1457: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1458:
1459: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1460: p_msg_name => OKC_API.G_INVALID_VALUE,
1461: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1462: p_token1_value => 'Quote id');
1463:
1464: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1461: p_token1 => OKC_API.G_COL_NAME_TOKEN,

1457: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1458:
1459: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1460: p_msg_name => OKC_API.G_INVALID_VALUE,
1461: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1462: p_token1_value => 'Quote id');
1463:
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465:

Line 3740: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,

3736:
3737: -- Check if quote id passed is valid
3738: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3739:
3740: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3741: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3742: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3743: p_token1_value => 'id');
3744:

Line 3741: p_msg_name => OKC_API.G_REQUIRED_VALUE,

3737: -- Check if quote id passed is valid
3738: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3739:
3740: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3741: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3742: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3743: p_token1_value => 'id');
3744:
3745: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3742: p_token1 => OKC_API.G_COL_NAME_TOKEN,

3738: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3739:
3740: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3741: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3742: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3743: p_token1_value => 'id');
3744:
3745: RAISE OKL_API.G_EXCEPTION_ERROR;
3746:

Line 3808: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,

3804:
3805: END IF;
3806: -- ELSE
3807:
3808: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3809: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
3810: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
3811: -- p_token1_value => 'qst_code');
3812: --

Line 3809: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,

3805: END IF;
3806: -- ELSE
3807:
3808: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3809: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
3810: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
3811: -- p_token1_value => 'qst_code');
3812: --
3813: -- RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3810: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,

3806: -- ELSE
3807:
3808: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3809: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
3810: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
3811: -- p_token1_value => 'qst_code');
3812: --
3813: -- RAISE OKL_API.G_EXCEPTION_ERROR;
3814:

Line 4087: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4083: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4084: END IF;
4085:
4086: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4087: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4088: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4089: -- x_return_status := l_return_status;
4090: -- END IF;
4091: -- END IF;

Line 4088: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4084: END IF;
4085:
4086: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4087: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4088: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4089: -- x_return_status := l_return_status;
4090: -- END IF;
4091: -- END IF;
4092:

Line 4124: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4120: END IF;
4121:
4122:
4123: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4124: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4125: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4126: -- x_return_status := l_return_status;
4127: -- END IF;
4128: -- END IF;

Line 4125: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4121:
4122:
4123: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4124: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4125: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4126: -- x_return_status := l_return_status;
4127: -- END IF;
4128: -- END IF;
4129:

Line 4212: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4208: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4209: END IF;
4210:
4211: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4212: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4213: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4214: -- x_return_status := l_return_status;
4215: -- END IF;
4216: -- END IF;

Line 4213: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4209: END IF;
4210:
4211: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4212: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4213: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4214: -- x_return_status := l_return_status;
4215: -- END IF;
4216: -- END IF;
4217:

Line 4236: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4232: END IF;
4233: END IF;
4234:
4235: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4236: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4237: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: -- x_return_status := l_return_status;
4239: -- END IF;
4240: -- END IF;

Line 4237: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4233: END IF;
4234:
4235: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4236: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4237: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4238: -- x_return_status := l_return_status;
4239: -- END IF;
4240: -- END IF;
4241:

Line 4262: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4258: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4259: END IF;
4260:
4261: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4262: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4263: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4264: -- x_return_status := l_return_status;
4265: -- END IF;
4266: -- END IF;

Line 4263: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4259: END IF;
4260:
4261: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4262: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4263: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4264: -- x_return_status := l_return_status;
4265: -- END IF;
4266: -- END IF;
4267:

Line 4289: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4285: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4286: END IF;
4287:
4288: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4289: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4290: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4291: -- x_return_status := l_return_status;
4292: -- END IF;
4293: -- END IF;

Line 4290: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4286: END IF;
4287:
4288: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4289: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4290: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4291: -- x_return_status := l_return_status;
4292: -- END IF;
4293: -- END IF;
4294:

Line 4303: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR

4299: IF x_return_status = OKL_API.G_RET_STS_ERROR OR
4300: l_return_status = OKL_API.G_RET_STS_ERROR THEN
4301: x_return_status := OKL_API.G_RET_STS_ERROR;
4302: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4303: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4304: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4307: END IF;

Line 4304: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

4300: l_return_status = OKL_API.G_RET_STS_ERROR THEN
4301: x_return_status := OKL_API.G_RET_STS_ERROR;
4302: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4303: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4304: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4307: END IF;
4308:

Line 4305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4301: x_return_status := OKL_API.G_RET_STS_ERROR;
4302: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4303: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4304: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4307: END IF;
4308:
4309: EXIT WHEN (i = l_qld_tbl.LAST);

Line 4306: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);

4302: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4303: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4304: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4305: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4306: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4307: END IF;
4308:
4309: EXIT WHEN (i = l_qld_tbl.LAST);
4310:

Line 4329: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4325: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called check_asset_sno , x_return_status : ' || x_return_status);
4326: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lv_sno_yn : ' || lv_sno_yn);
4327: END IF;
4328:
4329: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4330: RAISE G_EXCEPTION_HALT_VALIDATION;
4331: END IF;
4332:
4333: