DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKC_API

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

1507:
1508: -- Check if quote id passed is valid
1509: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1510:
1511: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1512: p_msg_name => OKC_API.G_INVALID_VALUE,
1513: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1514: p_token1_value => 'Quote id');
1515:

Line 1512: p_msg_name => OKC_API.G_INVALID_VALUE,

1508: -- Check if quote id passed is valid
1509: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1510:
1511: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1512: p_msg_name => OKC_API.G_INVALID_VALUE,
1513: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1514: p_token1_value => 'Quote id');
1515:
1516: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1513: p_token1 => OKC_API.G_COL_NAME_TOKEN,

1509: IF db_qte_id IS NULL OR db_qte_id = OKL_API.G_MISS_NUM THEN
1510:
1511: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
1512: p_msg_name => OKC_API.G_INVALID_VALUE,
1513: p_token1 => OKC_API.G_COL_NAME_TOKEN,
1514: p_token1_value => 'Quote id');
1515:
1516: RAISE OKL_API.G_EXCEPTION_ERROR;
1517:

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

3946:
3947: -- Check if quote id passed is valid
3948: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3949:
3950: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3951: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3952: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3953: p_token1_value => 'id');
3954:

Line 3951: p_msg_name => OKC_API.G_REQUIRED_VALUE,

3947: -- Check if quote id passed is valid
3948: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3949:
3950: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3951: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3952: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3953: p_token1_value => 'id');
3954:
3955: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 3952: p_token1 => OKC_API.G_COL_NAME_TOKEN,

3948: IF p_term_rec.id IS NULL OR p_term_rec.id = OKL_API.G_MISS_NUM THEN
3949:
3950: OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
3951: p_msg_name => OKC_API.G_REQUIRED_VALUE,
3952: p_token1 => OKC_API.G_COL_NAME_TOKEN,
3953: p_token1_value => 'id');
3954:
3955: RAISE OKL_API.G_EXCEPTION_ERROR;
3956:

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

4014:
4015: END IF;
4016: -- ELSE
4017:
4018: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
4019: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
4020: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
4021: -- p_token1_value => 'qst_code');
4022: --

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

4015: END IF;
4016: -- ELSE
4017:
4018: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
4019: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
4020: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
4021: -- p_token1_value => 'qst_code');
4022: --
4023: -- RAISE OKL_API.G_EXCEPTION_ERROR;

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

4016: -- ELSE
4017:
4018: -- OKL_API.set_message( p_app_name => OKC_API.G_APP_NAME,
4019: -- p_msg_name => OKC_API.G_REQUIRED_VALUE,
4020: -- p_token1 => OKC_API.G_COL_NAME_TOKEN,
4021: -- p_token1_value => 'qst_code');
4022: --
4023: -- RAISE OKL_API.G_EXCEPTION_ERROR;
4024:

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

4293: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4294: END IF;
4295:
4296: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4297: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4298: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4299: -- x_return_status := l_return_status;
4300: -- END IF;
4301: -- END IF;

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

4294: END IF;
4295:
4296: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4297: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4298: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4299: -- x_return_status := l_return_status;
4300: -- END IF;
4301: -- END IF;
4302:

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

4330: END IF;
4331:
4332:
4333: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4334: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4335: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4336: -- x_return_status := l_return_status;
4337: -- END IF;
4338: -- END IF;

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

4331:
4332:
4333: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4334: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4335: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4336: -- x_return_status := l_return_status;
4337: -- END IF;
4338: -- END IF;
4339:

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

4418: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4419: END IF;
4420:
4421: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4422: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4423: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4424: -- x_return_status := l_return_status;
4425: -- END IF;
4426: -- END IF;

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

4419: END IF;
4420:
4421: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4422: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4423: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4424: -- x_return_status := l_return_status;
4425: -- END IF;
4426: -- END IF;
4427:

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

4442: END IF;
4443: END IF;
4444:
4445: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4446: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4447: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4448: -- x_return_status := l_return_status;
4449: -- END IF;
4450: -- END IF;

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

4443: END IF;
4444:
4445: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4446: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4447: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4448: -- x_return_status := l_return_status;
4449: -- END IF;
4450: -- END IF;
4451:

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

4468: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4469: END IF;
4470:
4471: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4472: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4473: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4474: -- x_return_status := l_return_status;
4475: -- END IF;
4476: -- END IF;

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

4469: END IF;
4470:
4471: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4472: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4473: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4474: -- x_return_status := l_return_status;
4475: -- END IF;
4476: -- END IF;
4477:

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

4495: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4496: END IF;
4497:
4498: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4499: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4500: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4501: -- x_return_status := l_return_status;
4502: -- END IF;
4503: -- END IF;

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

4496: END IF;
4497:
4498: -- RMUNJULU 24-JAN-03 2759726 commented out this code
4499: -- IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4500: -- IF (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4501: -- x_return_status := l_return_status;
4502: -- END IF;
4503: -- END IF;
4504:

Line 4513: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR

4509: IF x_return_status = OKL_API.G_RET_STS_ERROR OR
4510: l_return_status = OKL_API.G_RET_STS_ERROR THEN
4511: x_return_status := OKL_API.G_RET_STS_ERROR;
4512: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4513: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4514: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4515: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4516: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4517: END IF;

Line 4514: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

4510: l_return_status = OKL_API.G_RET_STS_ERROR THEN
4511: x_return_status := OKL_API.G_RET_STS_ERROR;
4512: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4513: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4514: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4515: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4516: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4517: END IF;
4518:

Line 4515: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4511: x_return_status := OKL_API.G_RET_STS_ERROR;
4512: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4513: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4514: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4515: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4516: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4517: END IF;
4518:
4519: EXIT WHEN (i = l_qld_tbl.LAST);

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

4512: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
4513: ELSIF x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR OR
4514: l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
4515: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4516: EXIT WHEN (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR);
4517: END IF;
4518:
4519: EXIT WHEN (i = l_qld_tbl.LAST);
4520:

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

4535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called check_asset_sno , x_return_status : ' || x_return_status);
4536: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'lv_sno_yn : ' || lv_sno_yn);
4537: END IF;
4538:
4539: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4540: RAISE G_EXCEPTION_HALT_VALIDATION;
4541: END IF;
4542:
4543: