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_CONTRACT_PVT dependencies on OKC_API

Line 1014: p_restricted_update => OKC_API.G_FALSE,

1010: p_init_msg_list => p_init_msg_list,
1011: x_return_status => x_return_status,
1012: x_msg_count => x_msg_count,
1013: x_msg_data => x_msg_data,
1014: p_restricted_update => OKC_API.G_FALSE,
1015: p_clev_rec => l_clev_rec,
1016: x_clev_rec => lx_clev_rec);
1017:
1018: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

Line 1581: l_khrv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN

1577:
1578: -- Conversion type, date and rate mandetory
1579: IF (l_khrv_rec.currency_conversion_type IS NULL
1580: OR
1581: l_khrv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
1582: OKC_API.set_message(
1583: p_app_name => G_APP_NAME,
1584: p_msg_name => G_REQUIRED_VALUE,
1585: p_token1 => G_COL_NAME_TOKEN,

Line 1582: OKC_API.set_message(

1578: -- Conversion type, date and rate mandetory
1579: IF (l_khrv_rec.currency_conversion_type IS NULL
1580: OR
1581: l_khrv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
1582: OKC_API.set_message(
1583: p_app_name => G_APP_NAME,
1584: p_msg_name => G_REQUIRED_VALUE,
1585: p_token1 => G_COL_NAME_TOKEN,
1586: p_token1_value => 'Currency Conversion Type');

Line 1587: x_return_status := OKC_API.G_RET_STS_ERROR;

1583: p_app_name => G_APP_NAME,
1584: p_msg_name => G_REQUIRED_VALUE,
1585: p_token1 => G_COL_NAME_TOKEN,
1586: p_token1_value => 'Currency Conversion Type');
1587: x_return_status := OKC_API.G_RET_STS_ERROR;
1588: RAISE currency_validation_failed;
1589: END IF;
1590:
1591:

Line 1594: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN

1590:
1591:
1592: IF (l_khrv_rec.currency_conversion_date IS NULL
1593: OR
1594: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1595: If nvl(l_rbk_cpy,'N') <> 'Y' Then
1596: l_khrv_rec.currency_conversion_date := p_chrv_rec.start_date;
1597: End if;
1598: End IF;

Line 1610: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN

1606:
1607:
1608: IF (l_khrv_rec.currency_conversion_date IS NULL
1609: OR
1610: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1611: OKC_API.set_message(
1612: p_app_name => G_APP_NAME,
1613: p_msg_name => G_REQUIRED_VALUE,
1614: p_token1 => G_COL_NAME_TOKEN,

Line 1611: OKC_API.set_message(

1607:
1608: IF (l_khrv_rec.currency_conversion_date IS NULL
1609: OR
1610: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1611: OKC_API.set_message(
1612: p_app_name => G_APP_NAME,
1613: p_msg_name => G_REQUIRED_VALUE,
1614: p_token1 => G_COL_NAME_TOKEN,
1615: p_token1_value => 'Currency Conversion Date');

Line 1616: x_return_status := OKC_API.G_RET_STS_ERROR;

1612: p_app_name => G_APP_NAME,
1613: p_msg_name => G_REQUIRED_VALUE,
1614: p_token1 => G_COL_NAME_TOKEN,
1615: p_token1_value => 'Currency Conversion Date');
1616: x_return_status := OKC_API.G_RET_STS_ERROR;
1617: RAISE currency_validation_failed;
1618: END IF;
1619:
1620: IF (upper(l_khrv_rec.currency_conversion_type) = 'USER') THEN

Line 1624: l_khrv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN

1620: IF (upper(l_khrv_rec.currency_conversion_type) = 'USER') THEN
1621:
1622: IF (l_khrv_rec.currency_conversion_rate IS NULL
1623: OR
1624: l_khrv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
1625: OKC_API.set_message(
1626: p_app_name => G_APP_NAME,
1627: p_msg_name => G_REQUIRED_VALUE,
1628: p_token1 => G_COL_NAME_TOKEN,

Line 1625: OKC_API.set_message(

1621:
1622: IF (l_khrv_rec.currency_conversion_rate IS NULL
1623: OR
1624: l_khrv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
1625: OKC_API.set_message(
1626: p_app_name => G_APP_NAME,
1627: p_msg_name => G_REQUIRED_VALUE,
1628: p_token1 => G_COL_NAME_TOKEN,
1629: p_token1_value => 'Currency Conversion Rate');

Line 1630: x_return_status := OKC_API.G_RET_STS_ERROR;

1626: p_app_name => G_APP_NAME,
1627: p_msg_name => G_REQUIRED_VALUE,
1628: p_token1 => G_COL_NAME_TOKEN,
1629: p_token1_value => 'Currency Conversion Rate');
1630: x_return_status := OKC_API.G_RET_STS_ERROR;
1631: RAISE currency_validation_failed;
1632: END IF;
1633:
1634:

Line 1647: OKC_API.set_message(

1643: --since accounting util is returning -1 for all the rates not found
1644: --Bug# 2763523 : if rate not found api returnes -1 or -2 or any other negative value
1645: --If (l_khrv_rec.currency_conversion_rate = 0 ) OR (l_khrv_rec.currency_conversion_rate = -1)Then
1646: If (l_khrv_rec.currency_conversion_rate <= 0 ) Then
1647: OKC_API.set_message(
1648: p_app_name => G_APP_NAME,
1649: p_msg_name => G_CONV_RATE_NOT_FOUND,
1650: p_token1 => G_FROM_CURRENCY_TOKEN,
1651: p_token1_value => l_chrv_rec.currency_code,

Line 1658: x_return_status := OKC_API.G_RET_STS_ERROR;

1654: p_token3 => G_CONV_TYPE_TOKEN,
1655: p_token3_value => l_khrv_rec.currency_conversion_type,
1656: p_token4 => G_CONV_DATE_TOKEN,
1657: p_token4_value => to_char(l_khrv_rec.currency_conversion_date,'DD-MON-YYYY'));
1658: x_return_status := OKC_API.G_RET_STS_ERROR;
1659: RAISE currency_validation_failed;
1660: End If;
1661:
1662:

Line 1684: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1680: EXCEPTION
1681: WHEN currency_validation_failed THEN
1682: RETURN;
1683: WHEN others THEN
1684: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1685: END validate_currency;
1686: --Bug# : 11.5.9 Enhancement Multi-Currency Changes
1687: ---------------------------------------------------------------------------------
1688: -- Start of comments

Line 1874: OKC_API.set_message(

1870: null;
1871: end if;
1872: close get_pdtname_csr;
1873:
1874: OKC_API.set_message(
1875: p_app_name => G_APP_NAME,
1876: p_msg_name => G_PROD_PARAMS_NOT_FOUND,
1877: p_token1 => G_PROD_NAME_TOKEN ,
1878: p_token1_value => l_pdt_name);

Line 1893: OKC_API.set_message(

1889: If get_pdtname_csr%notfound then
1890: null;
1891: end if;
1892:
1893: OKC_API.set_message(
1894: p_app_name => G_APP_NAME,
1895: p_msg_name => G_PROD_MISSING_PARAM,
1896: p_token1 => G_PROD_PARAM_TOKEN,
1897: p_token1_value => 'Product Subclass',

Line 1914: OKC_API.set_message(

1910: Fetch get_pdtname_csr into l_pdt_name;
1911: If get_pdtname_csr%notfound then
1912: null;
1913: end if;
1914: OKC_API.set_message(
1915: p_app_name => G_APP_NAME,
1916: p_msg_name => G_PROD_MISSING_PARAM,
1917: p_token1 => G_PROD_PARAM_TOKEN,
1918: p_token1_value => 'Tax Owner',

Line 1937: OKC_API.set_message(

1933: Fetch get_pdtname_csr into l_pdt_name;
1934: If get_pdtname_csr%notfound then
1935: null;
1936: end if;
1937: OKC_API.set_message(
1938: p_app_name => G_APP_NAME,
1939: p_msg_name => G_PROD_MISSING_PARAM,
1940: p_token1 => G_PROD_PARAM_TOKEN,
1941: p_token1_value => 'Book Classification',

Line 1960: OKC_API.set_message(p_app_name => G_APP_NAME,

1956: Fetch get_pdtname_csr into l_pdt_name;
1957: If get_pdtname_csr%notfound then
1958: null;
1959: end if;
1960: OKC_API.set_message(p_app_name => G_APP_NAME,
1961: p_msg_name => G_PROD_SUBCALSS_MISMATCH,
1962: p_token1 => G_CONTRACT_SUBCLASS_TOKEN,
1963: p_token1_value => l_scs_code,
1964: p_token2 => G_PROD_SUBCALSS_TOKEN,

Line 1976: OKC_API.set_message(p_app_name => G_APP_NAME,

1972: Fetch get_pdtname_csr into l_pdt_name;
1973: If get_pdtname_csr%notfound then
1974: null;
1975: end if;
1976: OKC_API.set_message(p_app_name => G_APP_NAME,
1977: p_msg_name => G_PROD_SUBCALSS_MISMATCH,
1978: p_token1 => G_CONTRACT_SUBCLASS_TOKEN,
1979: p_token1_value => l_scs_code,
1980: p_token2 => G_PROD_SUBCALSS_TOKEN,

Line 4230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4226: -- Version :
4227: -- End of Commnets
4228: PROCEDURE delete_contract(
4229: p_api_version IN NUMBER,
4230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4231: x_return_status OUT NOCOPY VARCHAR2,
4232: x_msg_count OUT NOCOPY NUMBER,
4233: x_msg_data OUT NOCOPY VARCHAR2,
4234: p_contract_id IN okc_k_headers_b.id%TYPE) IS

Line 4328: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4324: WHERE dnz_chr_id = p_id;
4325:
4326: Begin
4327:
4328: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4329:
4330: FOR rec IN l_gvev_csr(p_chr_id)
4331: LOOP
4332:

Line 4345: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4341: p_gvev_tbl => l_gvev_tbl_in
4342: );
4343:
4344: If (l_return_status <> 'S') Then
4345: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4346: p_msg_name => G_CANNOT_DELETE,
4347: p_token1 => G_TABLE_NAME_TOKEN,
4348: p_token1_value => 'Governances',
4349: p_token2 => G_SQLCODE_TOKEN,

Line 4361: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4357: EXCEPTION
4358: -- other appropriate handlers
4359: When others then
4360: -- store SQL error message on message stack
4361: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4362: p_msg_name => G_UNEXPECTED_ERROR,
4363: p_token1 => G_SQLCODE_TOKEN,
4364: p_token1_value => sqlcode,
4365: p_token2 => G_SQLERRM_TOKEN,

Line 4369: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4365: p_token2 => G_SQLERRM_TOKEN,
4366: p_token2_value => sqlerrm);
4367:
4368: -- notify UNEXPECTED error
4369: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4370: return l_return_status;
4371: END DELETE_GOVERNANCES;
4372:
4373: FUNCTION DELETE_RULE_GROUPS( p_chr_id number) Return varchar2 IS

Line 4385: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4381: WHERE dnz_chr_id = p_id;
4382:
4383: Begin
4384:
4385: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4386:
4387: FOR rec IN l_rgpv_csr(p_chr_id)
4388: LOOP
4389: l_rgpv_tbl_in(1).ID := rec.id;

Line 4401: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4397: p_rgpv_tbl => l_rgpv_tbl_in
4398: );
4399:
4400: If (l_return_status <> 'S') Then
4401: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4402: p_msg_name => G_CANNOT_DELETE,
4403: p_token1 => G_TABLE_NAME_TOKEN,
4404: p_token1_value => 'Rule Groups',
4405: p_token2 => G_SQLCODE_TOKEN,

Line 4417: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4413: EXCEPTION
4414: -- other appropriate handlers
4415: When others then
4416: -- store SQL error message on message stack
4417: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4418: p_msg_name => G_UNEXPECTED_ERROR,
4419: p_token1 => G_SQLCODE_TOKEN,
4420: p_token1_value => sqlcode,
4421: p_token2 => G_SQLERRM_TOKEN,

Line 4425: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4421: p_token2 => G_SQLERRM_TOKEN,
4422: p_token2_value => sqlerrm);
4423:
4424: -- notify UNEXPECTED error
4425: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4426: return l_return_status;
4427: END DELETE_RULE_GROUPS;
4428:
4429: FUNCTION DELETE_K_PARTY_ROLES( p_chr_id number) Return varchar2 IS

Line 4444: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4440: --Bug# 4558486
4441: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;
4442: Begin
4443:
4444: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4445:
4446: FOR rec IN l_cplv_csr(p_chr_id)
4447: LOOP
4448: l_cplv_tbl_in(1).ID := rec.id;

Line 4466: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4462: p_kplv_tbl => l_kplv_tbl_in
4463: );
4464:
4465: If (l_return_status <> 'S') Then
4466: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4467: p_msg_name => G_CANNOT_DELETE,
4468: p_token1 => G_TABLE_NAME_TOKEN,
4469: p_token1_value => 'Contract Party Roles',
4470: p_token2 => G_SQLCODE_TOKEN,

Line 4482: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4478: EXCEPTION
4479: -- other appropriate handlers
4480: When others then
4481: -- store SQL error message on message stack
4482: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4483: p_msg_name => G_UNEXPECTED_ERROR,
4484: p_token1 => G_SQLCODE_TOKEN,
4485: p_token1_value => sqlcode,
4486: p_token2 => G_SQLERRM_TOKEN,

Line 4490: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4486: p_token2 => G_SQLERRM_TOKEN,
4487: p_token2_value => sqlerrm);
4488:
4489: -- notify UNEXPECTED error
4490: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4491: return l_return_status;
4492: END DELETE_K_PARTY_ROLES;
4493:
4494: FUNCTION DELETE_CONTACTS( p_chr_id number) Return varchar2 IS

Line 4505: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4501: FROM OKC_CONTACTS_V
4502: WHERE dnz_chr_id = p_id;
4503:
4504: Begin
4505: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4506:
4507: FOR rec IN l_ctc_csr(p_chr_id)
4508: LOOP
4509:

Line 4521: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4517: x_msg_data => x_msg_data,
4518: p_ctcv_tbl => l_ctcv_tbl_in);
4519:
4520: If (l_return_status <> 'S') Then
4521: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4522: p_msg_name => G_CANNOT_DELETE,
4523: p_token1 => G_TABLE_NAME_TOKEN,
4524: p_token1_value => 'Contacts',
4525: p_token2 => G_SQLCODE_TOKEN,

Line 4537: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4533: EXCEPTION
4534: -- other appropriate handlers
4535: When others then
4536: -- store SQL error message on message stack
4537: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4538: p_msg_name => G_UNEXPECTED_ERROR,
4539: p_token1 => G_SQLCODE_TOKEN,
4540: p_token1_value => sqlcode,
4541: p_token2 => G_SQLERRM_TOKEN,

Line 4545: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4541: p_token2 => G_SQLERRM_TOKEN,
4542: p_token2_value => sqlerrm);
4543:
4544: -- notify UNEXPECTED error
4545: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4546: return l_return_status;
4547: END DELETE_CONTACTS;
4548:
4549: FUNCTION DELETE_RG_PARTY_ROLES( p_chr_id number) Return varchar2 IS

Line 4561: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4557: WHERE dnz_chr_id = p_id;
4558:
4559: Begin
4560:
4561: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4562:
4563: FOR rec IN l_rmpv_csr(p_chr_id)
4564: LOOP
4565: l_rmpv_tbl_in(1).ID := rec.id;

Line 4577: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4573: p_rmpv_tbl => l_rmpv_tbl_in
4574: );
4575:
4576: If (l_return_status <> 'S') Then
4577: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4578: p_msg_name => G_CANNOT_DELETE,
4579: p_token1 => G_TABLE_NAME_TOKEN,
4580: p_token1_value => 'Rule Group Party Roles',
4581: p_token2 => G_SQLCODE_TOKEN,

Line 4593: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

4589: EXCEPTION
4590: -- other appropriate handlers
4591: When others then
4592: -- store SQL error message on message stack
4593: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4594: p_msg_name => G_UNEXPECTED_ERROR,
4595: p_token1 => G_SQLCODE_TOKEN,
4596: p_token1_value => sqlcode,
4597: p_token2 => G_SQLERRM_TOKEN,

Line 4601: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4597: p_token2 => G_SQLERRM_TOKEN,
4598: p_token2_value => sqlerrm);
4599:
4600: -- notify UNEXPECTED error
4601: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4602: return l_return_status;
4603: END DELETE_RG_PARTY_ROLES;
4604:
4605:

Line 7702: --12/10/01 ashish - changed this to call different okc api as we need to delete

7698: x_msg_data => x_msg_data,
7699: p_clev_rec => l_clev_rec);
7700:
7701:
7702: --12/10/01 ashish - changed this to call different okc api as we need to delete
7703: --okc_k_items automatically when okc_k_lines is deleted.
7704: --okc_contract_pub can be called directly here as there are no records involved
7705:
7706: --taken care of in another api with p_delete_cascade_yn flag

Line 8661: -- call OKC API first to delete contract line

8657: l_kplv_tbl.DELETE;
8658: End If;
8659: --Bug# 4558486
8660:
8661: -- call OKC API first to delete contract line
8662: okc_contract_pub.delete_contract_line(
8663: p_api_version => l_api_version,
8664: p_init_msg_list => p_init_msg_list,
8665: x_return_status => x_return_status,