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 1046: p_restricted_update => OKC_API.G_FALSE,

1042: p_init_msg_list => p_init_msg_list,
1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,
1046: p_restricted_update => OKC_API.G_FALSE,
1047: p_clev_rec => l_clev_rec,
1048: x_clev_rec => lx_clev_rec);
1049:
1050: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

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

1609:
1610: -- Conversion type, date and rate mandetory
1611: IF (l_khrv_rec.currency_conversion_type IS NULL
1612: OR
1613: l_khrv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
1614: OKC_API.set_message(
1615: p_app_name => G_APP_NAME,
1616: p_msg_name => G_REQUIRED_VALUE,
1617: p_token1 => G_COL_NAME_TOKEN,

Line 1614: OKC_API.set_message(

1610: -- Conversion type, date and rate mandetory
1611: IF (l_khrv_rec.currency_conversion_type IS NULL
1612: OR
1613: l_khrv_rec.currency_conversion_type = OKC_API.G_MISS_CHAR) THEN
1614: OKC_API.set_message(
1615: p_app_name => G_APP_NAME,
1616: p_msg_name => G_REQUIRED_VALUE,
1617: p_token1 => G_COL_NAME_TOKEN,
1618: p_token1_value => 'Currency Conversion Type');

Line 1619: x_return_status := OKC_API.G_RET_STS_ERROR;

1615: p_app_name => G_APP_NAME,
1616: p_msg_name => G_REQUIRED_VALUE,
1617: p_token1 => G_COL_NAME_TOKEN,
1618: p_token1_value => 'Currency Conversion Type');
1619: x_return_status := OKC_API.G_RET_STS_ERROR;
1620: RAISE currency_validation_failed;
1621: END IF;
1622:
1623:

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

1622:
1623:
1624: IF (l_khrv_rec.currency_conversion_date IS NULL
1625: OR
1626: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1627: If nvl(l_rbk_cpy,'N') <> 'Y' Then
1628: l_khrv_rec.currency_conversion_date := p_chrv_rec.start_date;
1629: End if;
1630: End IF;

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

1638:
1639:
1640: IF (l_khrv_rec.currency_conversion_date IS NULL
1641: OR
1642: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1643: OKC_API.set_message(
1644: p_app_name => G_APP_NAME,
1645: p_msg_name => G_REQUIRED_VALUE,
1646: p_token1 => G_COL_NAME_TOKEN,

Line 1643: OKC_API.set_message(

1639:
1640: IF (l_khrv_rec.currency_conversion_date IS NULL
1641: OR
1642: l_khrv_rec.currency_conversion_date = OKC_API.G_MISS_DATE) THEN
1643: OKC_API.set_message(
1644: p_app_name => G_APP_NAME,
1645: p_msg_name => G_REQUIRED_VALUE,
1646: p_token1 => G_COL_NAME_TOKEN,
1647: p_token1_value => 'Currency Conversion Date');

Line 1648: x_return_status := OKC_API.G_RET_STS_ERROR;

1644: p_app_name => G_APP_NAME,
1645: p_msg_name => G_REQUIRED_VALUE,
1646: p_token1 => G_COL_NAME_TOKEN,
1647: p_token1_value => 'Currency Conversion Date');
1648: x_return_status := OKC_API.G_RET_STS_ERROR;
1649: RAISE currency_validation_failed;
1650: END IF;
1651:
1652: IF (upper(l_khrv_rec.currency_conversion_type) = 'USER') THEN

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

1652: IF (upper(l_khrv_rec.currency_conversion_type) = 'USER') THEN
1653:
1654: IF (l_khrv_rec.currency_conversion_rate IS NULL
1655: OR
1656: l_khrv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
1657: OKC_API.set_message(
1658: p_app_name => G_APP_NAME,
1659: p_msg_name => G_REQUIRED_VALUE,
1660: p_token1 => G_COL_NAME_TOKEN,

Line 1657: OKC_API.set_message(

1653:
1654: IF (l_khrv_rec.currency_conversion_rate IS NULL
1655: OR
1656: l_khrv_rec.currency_conversion_rate = OKC_API.G_MISS_NUM) THEN
1657: OKC_API.set_message(
1658: p_app_name => G_APP_NAME,
1659: p_msg_name => G_REQUIRED_VALUE,
1660: p_token1 => G_COL_NAME_TOKEN,
1661: p_token1_value => 'Currency Conversion Rate');

Line 1662: x_return_status := OKC_API.G_RET_STS_ERROR;

1658: p_app_name => G_APP_NAME,
1659: p_msg_name => G_REQUIRED_VALUE,
1660: p_token1 => G_COL_NAME_TOKEN,
1661: p_token1_value => 'Currency Conversion Rate');
1662: x_return_status := OKC_API.G_RET_STS_ERROR;
1663: RAISE currency_validation_failed;
1664: END IF;
1665:
1666:

Line 1679: OKC_API.set_message(

1675: --since accounting util is returning -1 for all the rates not found
1676: --Bug# 2763523 : if rate not found api returnes -1 or -2 or any other negative value
1677: --If (l_khrv_rec.currency_conversion_rate = 0 ) OR (l_khrv_rec.currency_conversion_rate = -1)Then
1678: If (l_khrv_rec.currency_conversion_rate <= 0 ) Then
1679: OKC_API.set_message(
1680: p_app_name => G_APP_NAME,
1681: p_msg_name => G_CONV_RATE_NOT_FOUND,
1682: p_token1 => G_FROM_CURRENCY_TOKEN,
1683: p_token1_value => l_chrv_rec.currency_code,

Line 1690: x_return_status := OKC_API.G_RET_STS_ERROR;

1686: p_token3 => G_CONV_TYPE_TOKEN,
1687: p_token3_value => l_khrv_rec.currency_conversion_type,
1688: p_token4 => G_CONV_DATE_TOKEN,
1689: p_token4_value => to_char(l_khrv_rec.currency_conversion_date,'DD-MON-YYYY'));
1690: x_return_status := OKC_API.G_RET_STS_ERROR;
1691: RAISE currency_validation_failed;
1692: End If;
1693:
1694:

Line 1716: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1712: EXCEPTION
1713: WHEN currency_validation_failed THEN
1714: RETURN;
1715: WHEN others THEN
1716: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1717: END validate_currency;
1718: --Bug# : 11.5.9 Enhancement Multi-Currency Changes
1719: ---------------------------------------------------------------------------------
1720: -- Start of comments

Line 1933: OKC_API.set_message(

1929: null;
1930: end if;
1931: close get_pdtname_csr;
1932:
1933: OKC_API.set_message(
1934: p_app_name => G_APP_NAME,
1935: p_msg_name => G_PROD_PARAMS_NOT_FOUND,
1936: p_token1 => G_PROD_NAME_TOKEN ,
1937: p_token1_value => l_pdt_name);

Line 1952: OKC_API.set_message(

1948: If get_pdtname_csr%notfound then
1949: null;
1950: end if;
1951:
1952: OKC_API.set_message(
1953: p_app_name => G_APP_NAME,
1954: p_msg_name => G_PROD_MISSING_PARAM,
1955: p_token1 => G_PROD_PARAM_TOKEN,
1956: p_token1_value => 'Product Subclass',

Line 1973: OKC_API.set_message(

1969: Fetch get_pdtname_csr into l_pdt_name;
1970: If get_pdtname_csr%notfound then
1971: null;
1972: end if;
1973: OKC_API.set_message(
1974: p_app_name => G_APP_NAME,
1975: p_msg_name => G_PROD_MISSING_PARAM,
1976: p_token1 => G_PROD_PARAM_TOKEN,
1977: p_token1_value => 'Tax Owner',

Line 1996: OKC_API.set_message(

1992: Fetch get_pdtname_csr into l_pdt_name;
1993: If get_pdtname_csr%notfound then
1994: null;
1995: end if;
1996: OKC_API.set_message(
1997: p_app_name => G_APP_NAME,
1998: p_msg_name => G_PROD_MISSING_PARAM,
1999: p_token1 => G_PROD_PARAM_TOKEN,
2000: p_token1_value => 'Book Classification',

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

2015: Fetch get_pdtname_csr into l_pdt_name;
2016: If get_pdtname_csr%notfound then
2017: null;
2018: end if;
2019: OKC_API.set_message(p_app_name => G_APP_NAME,
2020: p_msg_name => G_PROD_SUBCALSS_MISMATCH,
2021: p_token1 => G_CONTRACT_SUBCLASS_TOKEN,
2022: p_token1_value => l_scs_code,
2023: p_token2 => G_PROD_SUBCALSS_TOKEN,

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

2031: Fetch get_pdtname_csr into l_pdt_name;
2032: If get_pdtname_csr%notfound then
2033: null;
2034: end if;
2035: OKC_API.set_message(p_app_name => G_APP_NAME,
2036: p_msg_name => G_PROD_SUBCALSS_MISMATCH,
2037: p_token1 => G_CONTRACT_SUBCLASS_TOKEN,
2038: p_token1_value => l_scs_code,
2039: p_token2 => G_PROD_SUBCALSS_TOKEN,

Line 4315: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4311: -- Version :
4312: -- End of Commnets
4313: PROCEDURE delete_contract(
4314: p_api_version IN NUMBER,
4315: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4316: x_return_status OUT NOCOPY VARCHAR2,
4317: x_msg_count OUT NOCOPY NUMBER,
4318: x_msg_data OUT NOCOPY VARCHAR2,
4319: p_contract_id IN okc_k_headers_b.id%TYPE) IS

Line 4413: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4409: WHERE dnz_chr_id = p_id;
4410:
4411: Begin
4412:
4413: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4414:
4415: FOR rec IN l_gvev_csr(p_chr_id)
4416: LOOP
4417:

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

4426: p_gvev_tbl => l_gvev_tbl_in
4427: );
4428:
4429: If (l_return_status <> 'S') Then
4430: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4431: p_msg_name => G_CANNOT_DELETE,
4432: p_token1 => G_TABLE_NAME_TOKEN,
4433: p_token1_value => 'Governances',
4434: p_token2 => G_SQLCODE_TOKEN,

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

4442: EXCEPTION
4443: -- other appropriate handlers
4444: When others then
4445: -- store SQL error message on message stack
4446: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4447: p_msg_name => G_UNEXPECTED_ERROR,
4448: p_token1 => G_SQLCODE_TOKEN,
4449: p_token1_value => sqlcode,
4450: p_token2 => G_SQLERRM_TOKEN,

Line 4454: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4450: p_token2 => G_SQLERRM_TOKEN,
4451: p_token2_value => sqlerrm);
4452:
4453: -- notify UNEXPECTED error
4454: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4455: return l_return_status;
4456: END DELETE_GOVERNANCES;
4457:
4458: FUNCTION DELETE_RULE_GROUPS( p_chr_id number) Return varchar2 IS

Line 4470: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4466: WHERE dnz_chr_id = p_id;
4467:
4468: Begin
4469:
4470: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4471:
4472: FOR rec IN l_rgpv_csr(p_chr_id)
4473: LOOP
4474: l_rgpv_tbl_in(1).ID := rec.id;

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

4482: p_rgpv_tbl => l_rgpv_tbl_in
4483: );
4484:
4485: If (l_return_status <> 'S') Then
4486: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4487: p_msg_name => G_CANNOT_DELETE,
4488: p_token1 => G_TABLE_NAME_TOKEN,
4489: p_token1_value => 'Rule Groups',
4490: p_token2 => G_SQLCODE_TOKEN,

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

4498: EXCEPTION
4499: -- other appropriate handlers
4500: When others then
4501: -- store SQL error message on message stack
4502: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4503: p_msg_name => G_UNEXPECTED_ERROR,
4504: p_token1 => G_SQLCODE_TOKEN,
4505: p_token1_value => sqlcode,
4506: p_token2 => G_SQLERRM_TOKEN,

Line 4510: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4506: p_token2 => G_SQLERRM_TOKEN,
4507: p_token2_value => sqlerrm);
4508:
4509: -- notify UNEXPECTED error
4510: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4511: return l_return_status;
4512: END DELETE_RULE_GROUPS;
4513:
4514: FUNCTION DELETE_K_PARTY_ROLES( p_chr_id number) Return varchar2 IS

Line 4529: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4525: --Bug# 4558486
4526: l_kplv_tbl_in OKL_K_PARTY_ROLES_PVT.kplv_tbl_type;
4527: Begin
4528:
4529: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4530:
4531: FOR rec IN l_cplv_csr(p_chr_id)
4532: LOOP
4533: l_cplv_tbl_in(1).ID := rec.id;

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

4547: p_kplv_tbl => l_kplv_tbl_in
4548: );
4549:
4550: If (l_return_status <> 'S') Then
4551: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4552: p_msg_name => G_CANNOT_DELETE,
4553: p_token1 => G_TABLE_NAME_TOKEN,
4554: p_token1_value => 'Contract Party Roles',
4555: p_token2 => G_SQLCODE_TOKEN,

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

4563: EXCEPTION
4564: -- other appropriate handlers
4565: When others then
4566: -- store SQL error message on message stack
4567: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4568: p_msg_name => G_UNEXPECTED_ERROR,
4569: p_token1 => G_SQLCODE_TOKEN,
4570: p_token1_value => sqlcode,
4571: p_token2 => G_SQLERRM_TOKEN,

Line 4575: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4571: p_token2 => G_SQLERRM_TOKEN,
4572: p_token2_value => sqlerrm);
4573:
4574: -- notify UNEXPECTED error
4575: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4576: return l_return_status;
4577: END DELETE_K_PARTY_ROLES;
4578:
4579: FUNCTION DELETE_CONTACTS( p_chr_id number) Return varchar2 IS

Line 4590: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4586: FROM OKC_CONTACTS_V
4587: WHERE dnz_chr_id = p_id;
4588:
4589: Begin
4590: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4591:
4592: FOR rec IN l_ctc_csr(p_chr_id)
4593: LOOP
4594:

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

4602: x_msg_data => x_msg_data,
4603: p_ctcv_tbl => l_ctcv_tbl_in);
4604:
4605: If (l_return_status <> 'S') Then
4606: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4607: p_msg_name => G_CANNOT_DELETE,
4608: p_token1 => G_TABLE_NAME_TOKEN,
4609: p_token1_value => 'Contacts',
4610: p_token2 => G_SQLCODE_TOKEN,

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

4618: EXCEPTION
4619: -- other appropriate handlers
4620: When others then
4621: -- store SQL error message on message stack
4622: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4623: p_msg_name => G_UNEXPECTED_ERROR,
4624: p_token1 => G_SQLCODE_TOKEN,
4625: p_token1_value => sqlcode,
4626: p_token2 => G_SQLERRM_TOKEN,

Line 4630: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4626: p_token2 => G_SQLERRM_TOKEN,
4627: p_token2_value => sqlerrm);
4628:
4629: -- notify UNEXPECTED error
4630: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4631: return l_return_status;
4632: END DELETE_CONTACTS;
4633:
4634: FUNCTION DELETE_RG_PARTY_ROLES( p_chr_id number) Return varchar2 IS

Line 4646: l_return_status := OKC_API.G_RET_STS_SUCCESS;

4642: WHERE dnz_chr_id = p_id;
4643:
4644: Begin
4645:
4646: l_return_status := OKC_API.G_RET_STS_SUCCESS;
4647:
4648: FOR rec IN l_rmpv_csr(p_chr_id)
4649: LOOP
4650: l_rmpv_tbl_in(1).ID := rec.id;

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

4658: p_rmpv_tbl => l_rmpv_tbl_in
4659: );
4660:
4661: If (l_return_status <> 'S') Then
4662: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4663: p_msg_name => G_CANNOT_DELETE,
4664: p_token1 => G_TABLE_NAME_TOKEN,
4665: p_token1_value => 'Rule Group Party Roles',
4666: p_token2 => G_SQLCODE_TOKEN,

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

4674: EXCEPTION
4675: -- other appropriate handlers
4676: When others then
4677: -- store SQL error message on message stack
4678: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
4679: p_msg_name => G_UNEXPECTED_ERROR,
4680: p_token1 => G_SQLCODE_TOKEN,
4681: p_token1_value => sqlcode,
4682: p_token2 => G_SQLERRM_TOKEN,

Line 4686: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

4682: p_token2 => G_SQLERRM_TOKEN,
4683: p_token2_value => sqlerrm);
4684:
4685: -- notify UNEXPECTED error
4686: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4687: return l_return_status;
4688: END DELETE_RG_PARTY_ROLES;
4689:
4690:

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

7800: x_msg_data => x_msg_data,
7801: p_clev_rec => l_clev_rec);
7802:
7803:
7804: --12/10/01 ashish - changed this to call different okc api as we need to delete
7805: --okc_k_items automatically when okc_k_lines is deleted.
7806: --okc_contract_pub can be called directly here as there are no records involved
7807:
7808: --taken care of in another api with p_delete_cascade_yn flag

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

8759: l_kplv_tbl.DELETE;
8760: End If;
8761: --Bug# 4558486
8762:
8763: -- call OKC API first to delete contract line
8764: okc_contract_pub.delete_contract_line(
8765: p_api_version => l_api_version,
8766: p_init_msg_list => p_init_msg_list,
8767: x_return_status => x_return_status,