eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_TERMNT_VENDOR_PRG_PVT dependencies on OKL_API

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

51: -- *********************
52: -- GLOBAL VARIABLES
53: -- *********************
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_TERMNT_VENDOR_PRG_PVT';
55: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
56: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

53: -- *********************
54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_TERMNT_VENDOR_PRG_PVT';
55: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
56: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

Line 58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

54: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AM_TERMNT_VENDOR_PRG_PVT';
55: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
56: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

Line 59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

55: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
56: G_APP_NAME_1 CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

Line 61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;

57: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

Line 62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;

58: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
66: G_YES CONSTANT VARCHAR2(1) := 'Y';

Line 63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;

59: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
66: G_YES CONSTANT VARCHAR2(1) := 'Y';
67: G_NO CONSTANT VARCHAR2(1) := 'N';

Line 64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;

60: G_API_VERSION CONSTANT NUMBER := 1;
61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
66: G_YES CONSTANT VARCHAR2(1) := 'Y';
67: G_NO CONSTANT VARCHAR2(1) := 'N';
68: G_FIRST CONSTANT NUMBER := FND_MSG_PUB.G_FIRST;

Line 65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;

61: G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
62: G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
63: G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
64: G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
65: G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
66: G_YES CONSTANT VARCHAR2(1) := 'Y';
67: G_NO CONSTANT VARCHAR2(1) := 'N';
68: G_FIRST CONSTANT NUMBER := FND_MSG_PUB.G_FIRST;
69: G_NEXT CONSTANT NUMBER := FND_MSG_PUB.G_NEXT;

Line 104: lx_error_rec OKL_API.error_rec_type;

100: PROCEDURE fnd_output (
101: p_va_rec IN va_rec_type,
102: p_control_flag IN VARCHAR2 ) IS
103:
104: lx_error_rec OKL_API.error_rec_type;
105: l_msg_idx INTEGER := G_FIRST;
106:
107: BEGIN
108:

Line 159: OKL_API.set_message(

155: EXCEPTION
156:
157: WHEN OTHERS THEN
158: -- Set the oracle error message
159: OKL_API.set_message(
160: p_app_name => G_APP_NAME_1,
161: p_msg_name => G_UNEXPECTED_ERROR,
162: p_token1 => G_SQLCODE_TOKEN,
163: p_token1_value => SQLCODE,

Line 429: OKL_API.set_message(

425: EXCEPTION
426:
427: WHEN OTHERS THEN
428: -- Set the oracle error message
429: OKL_API.set_message(
430: p_app_name => G_APP_NAME_1,
431: p_msg_name => G_UNEXPECTED_ERROR,
432: p_token1 => G_SQLCODE_TOKEN,
433: p_token1_value => SQLCODE,

Line 528: OR get_va_details_rec.id = OKL_API.G_MISS_NUM THEN

524: IF p_control_flag = 'BATCH_SINGLE' THEN -- Do additional checks
525:
526: -- Check for ID
527: IF get_va_details_rec.id IS NULL
528: OR get_va_details_rec.id = OKL_API.G_MISS_NUM THEN
529:
530: -- Message: Invalid value for Vendor Program ID.
531: OKL_API.set_message(
532: p_app_name => G_APP_NAME,

Line 531: OKL_API.set_message(

527: IF get_va_details_rec.id IS NULL
528: OR get_va_details_rec.id = OKL_API.G_MISS_NUM THEN
529:
530: -- Message: Invalid value for Vendor Program ID.
531: OKL_API.set_message(
532: p_app_name => G_APP_NAME,
533: p_msg_name => 'OKL_AM_VPA_ID_INVALID');
534:
535: RAISE G_EXCEPTION_ERROR;

Line 542: OKL_API.set_message(

538: -- Check for type
539: IF get_va_details_rec.scs_code NOT IN ('PROGRAM','OPERATING') THEN
540:
541: -- Message: Invalid value for Program Type for Vendor Program VPA_NUMBER.
542: OKL_API.set_message(
543: p_app_name => G_APP_NAME,
544: p_msg_name => 'OKL_AM_VPA_TYPE_INVALID',
545: p_token1 => 'VPA_NUMBER',
546: p_token1_value => get_va_details_rec.va_number);

Line 555: OKL_API.set_message(

551: -- Check for status
552: IF get_va_details_rec.sts_code NOT IN ('ACTIVE') THEN
553:
554: -- Message: Invalid value for Program Status for Vendor Program VPA_NUMBER.
555: OKL_API.set_message(
556: p_app_name => G_APP_NAME,
557: p_msg_name => 'OKL_AM_VPA_STATUS_INVALID',
558: p_token1 => 'VPA_NUMBER',
559: p_token1_value => get_va_details_rec.va_number);

Line 568: OKL_API.set_message(

564: -- Check for end date
565: IF trunc(get_va_details_rec.end_date) > G_VPA_ENDED_BY_DATE THEN -- G_VPA_ENDED_BY_DATE is passed by user
566:
567: -- Message: Program VPA_NUMBER has not reached its end date.
568: OKL_API.set_message(
569: p_app_name => G_APP_NAME,
570: p_msg_name => 'OKL_AM_VPA_END_DATE_INVALID',
571: p_token1 => 'VPA_NUMBER',
572: p_token1_value => get_va_details_rec.va_number);

Line 616: OKL_API.set_message(

612:
613: WHEN OTHERS THEN
614: ROLLBACK TO validate_va_trx;
615: -- Set the oracle error message
616: OKL_API.set_message(
617: p_app_name => G_APP_NAME_1,
618: p_msg_name => G_UNEXPECTED_ERROR,
619: p_token1 => G_SQLCODE_TOKEN,
620: p_token1_value => SQLCODE,

Line 741: OKL_API.set_message(

737:
738: IF l_return_status <> G_RET_STS_SUCCESS THEN
739:
740: -- Message: Unable to find a transaction type for the transaction TRY_NAME -- Seeded
741: OKL_API.set_message(
742: p_app_name => G_APP_NAME,
743: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
744: p_token1 => 'TRY_NAME',
745: p_token1_value => l_trans_meaning);

Line 776: OKL_API.set_message(

772: -- Set msg if error
773: IF l_return_status <> G_RET_STS_SUCCESS THEN
774: -- Error occured while creating termination transaction for the
775: -- Investor Agreement AGREEMENT_NUMBER..
776: OKL_API.set_message(
777: p_app_name => G_APP_NAME,
778: p_msg_name => 'OKL_AM_INV_TRN_CREATE_ERR');
779: END IF;
780:

Line 830: OKL_API.set_message(

826: WHEN OTHERS THEN
827: ROLLBACK TO pop_insert_trn_trx;
828:
829: -- Set the oracle error message
830: OKL_API.set_message(
831: p_app_name => G_APP_NAME_1,
832: p_msg_name => G_UNEXPECTED_ERROR,
833: p_token1 => G_SQLCODE_TOKEN,
834: p_token1_value => SQLCODE,

Line 930: OKL_API.set_message(

926:
927: -- Set msg if error
928: IF l_return_status <> G_RET_STS_SUCCESS THEN
929: -- Message: Error updating Program Agreement VPA_NUMBER.
930: OKL_API.set_message(
931: p_app_name => G_APP_NAME,
932: p_msg_name => 'OKL_AM_VPA_UPD_TRN_ERR',
933: p_token1 => 'AGREEMENT_NUMBER',
934: p_token1_value => p_va_rec.va_number);

Line 980: OKL_API.set_message(

976: WHEN OTHERS THEN
977: ROLLBACK TO update_transaction_trx;
978:
979: -- Set the oracle error message
980: OKL_API.set_message(
981: p_app_name => G_APP_NAME_1,
982: p_msg_name => G_UNEXPECTED_ERROR,
983: p_token1 => G_SQLCODE_TOKEN,
984: p_token1_value => SQLCODE,

Line 1061: OKL_API.set_message(

1057: END IF;
1058:
1059: IF l_return_status <> G_RET_STS_SUCCESS THEN
1060: -- Message : Error updating Program Agreement VPA_NUMBER.
1061: OKL_API.set_message(
1062: p_app_name => G_APP_NAME,
1063: p_msg_name => 'OKL_AM_VPA_TRMNT_ERR',
1064: p_token1 => 'VPA_NUMBER',
1065: p_token1_value => px_va_rec.va_number);

Line 1112: OKL_API.set_message(

1108:
1109: WHEN OTHERS THEN
1110: ROLLBACK TO update_vpa_trx;
1111: -- Set the oracle error message
1112: OKL_API.set_message(
1113: p_app_name => G_APP_NAME_1,
1114: p_msg_name => G_UNEXPECTED_ERROR,
1115: p_token1 => G_SQLCODE_TOKEN,
1116: p_token1_value => SQLCODE,

Line 1143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1139: --
1140: -- End of comments
1141: PROCEDURE terminate_vendor_prog(
1142: p_api_version IN NUMBER,
1143: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1144: x_return_status OUT NOCOPY VARCHAR2,
1145: x_msg_count OUT NOCOPY NUMBER,
1146: x_msg_data OUT NOCOPY VARCHAR2,
1147: p_va_rec IN va_rec_type,

Line 1168: lx_error_rec OKL_API.error_rec_type;

1164: l_step VARCHAR2(50);
1165: l_validate_status VARCHAR2(3);
1166: l_update_status VARCHAR2(3);
1167:
1168: lx_error_rec OKL_API.error_rec_type;
1169: l_msg_idx INTEGER := G_FIRST;
1170: l_msg_tbl msg_tbl_type;
1171: l_api_name VARCHAR2(30) := 'terminate_vendor_prg';
1172: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 1187: l_return_status := OKL_API.start_activity(

1183:
1184: -- *************
1185: -- Check API version, initialize message list and create savepoint
1186: -- *************
1187: l_return_status := OKL_API.start_activity(
1188: p_api_name => l_api_name,
1189: p_pkg_name => G_PKG_NAME,
1190: p_init_msg_list => p_init_msg_list,
1191: l_api_version => l_api_version,

Line 1290: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN

1286: */
1287: -- *************
1288: -- Update VPA
1289: -- *************
1290: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
1291:
1292: update_vendor_prg(
1293: p_va_rec => p_va_rec,
1294: p_control_flag => p_control_flag,

Line 1369: OKL_API.end_activity (x_msg_count, x_msg_data);

1365: -- set return status
1366: x_return_status := l_return_status;
1367:
1368: -- End Activity
1369: OKL_API.end_activity (x_msg_count, x_msg_data);
1370:
1371: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1372: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1373: 'OKL_AM_TERMNT_VENDOR_PRG_PVT.terminate_vendor_prog.',

Line 1388: x_return_status := OKL_API.handle_exceptions(

1384: p_va_rec => l_va_rec,
1385: p_control_flag => 'ERROR');
1386: END IF;
1387:
1388: x_return_status := OKL_API.handle_exceptions(
1389: p_api_name => l_api_name,
1390: p_pkg_name => G_PKG_NAME,
1391: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1392: x_msg_count => x_msg_count,

Line 1391: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1387:
1388: x_return_status := OKL_API.handle_exceptions(
1389: p_api_name => l_api_name,
1390: p_pkg_name => G_PKG_NAME,
1391: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1392: x_msg_count => x_msg_count,
1393: x_msg_data => x_msg_data,
1394: p_api_type => '_PVT');
1395:

Line 1411: x_return_status := OKL_API.handle_exceptions(

1407: p_va_rec => l_va_rec,
1408: p_control_flag => 'ERROR');
1409: END IF;
1410:
1411: x_return_status := OKL_API.handle_exceptions(
1412: p_api_name => l_api_name,
1413: p_pkg_name => G_PKG_NAME,
1414: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1415: x_msg_count => x_msg_count,

Line 1414: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1410:
1411: x_return_status := OKL_API.handle_exceptions(
1412: p_api_name => l_api_name,
1413: p_pkg_name => G_PKG_NAME,
1414: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1415: x_msg_count => x_msg_count,
1416: x_msg_data => x_msg_data,
1417: p_api_type => '_PVT');
1418:

Line 1434: x_return_status := OKL_API.handle_exceptions(

1430: p_va_rec => l_va_rec,
1431: p_control_flag => 'ERROR');
1432: END IF;
1433:
1434: x_return_status := OKL_API.handle_exceptions(
1435: p_api_name => l_api_name,
1436: p_pkg_name => G_PKG_NAME,
1437: p_exc_name => 'OTHERS',
1438: x_msg_count => x_msg_count,

Line 1470: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1466: PROCEDURE concurrent_expire_vend_prg(
1467: errbuf OUT NOCOPY VARCHAR2,
1468: retcode OUT NOCOPY VARCHAR2,
1469: p_api_version IN VARCHAR2,
1470: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1471: p_va_id IN VARCHAR2 DEFAULT NULL,
1472: p_date IN VARCHAR2 DEFAULT NULL) IS
1473:
1474: -- Get the VPAs which have reached their end_date and still active

Line 1496: OKL_API.init_msg_list('T');

1492:
1493: BEGIN
1494:
1495: -- Initialize message list
1496: OKL_API.init_msg_list('T');
1497:
1498: -- Set Processing date
1499: IF p_date IS NULL THEN
1500: l_date := sysdate;

Line 1560: OKL_API.set_message(

1556: EXCEPTION
1557:
1558: WHEN OTHERS THEN
1559: -- Set the oracle error message
1560: OKL_API.set_message(
1561: p_app_name => G_APP_NAME_1,
1562: p_msg_name => G_UNEXPECTED_ERROR,
1563: p_token1 => G_SQLCODE_TOKEN,
1564: p_token1_value => SQLCODE,