DBA Data[Home] [Help]

APPS.OKE_FUNDING_UTIL_PKG dependencies on OKE_API

Line 1307: x_commit IN VARCHAR2 := OKE_API.G_FALSE

1303: --
1304:
1305: PROCEDURE update_alloc_version(x_fund_allocation_id IN NUMBER,
1306: x_version_add IN NUMBER,
1307: x_commit IN VARCHAR2 := OKE_API.G_FALSE
1308: ) is
1309:
1310: begin
1311:

Line 1338: x_commit IN VARCHAR2 := OKE_API.G_FALSE

1334: -- x_commit varchar2 commit flag
1335: --
1336:
1337: PROCEDURE update_source_flag(x_funding_source_id IN NUMBER,
1338: x_commit IN VARCHAR2 := OKE_API.G_FALSE
1339: ) is
1340: l_flag VARCHAR2(1) := 'N';
1341: CURSOR c_agr IS
1342: SELECT 'Y'

Line 1574: OKE_API.set_message(p_app_name => G_APP_NAME ,

1570: );
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: OKE_API.set_message(p_app_name => G_APP_NAME ,
1575: p_msg_name => G_UNEXPECTED_ERROR ,
1576: p_token1 => G_SQLCODE_TOKEN ,
1577: p_token1_value => SQLCODE ,
1578: p_token2 => G_SQLERRM_TOKEN ,

Line 1638: OKE_API.set_message(p_app_name => G_APP_NAME ,

1634: IF (x_project_currency <> x_fund_currency) THEN
1635:
1636: IF (x_conversion_type is null) THEN
1637:
1638: OKE_API.set_message(p_app_name => G_APP_NAME ,
1639: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1640: p_token1 => 'VALUE' ,
1641: p_token1_value => 'pa_conversion_type'
1642: );

Line 1639: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1635:
1636: IF (x_conversion_type is null) THEN
1637:
1638: OKE_API.set_message(p_app_name => G_APP_NAME ,
1639: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1640: p_token1 => 'VALUE' ,
1641: p_token1_value => 'pa_conversion_type'
1642: );
1643:

Line 1650: OKE_API.set_message(p_app_name => G_APP_NAME ,

1646: END IF;
1647:
1648: IF (x_conversion_date is null) THEN
1649:
1650: OKE_API.set_message(p_app_name => G_APP_NAME ,
1651: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1652: p_token1 => 'VALUE' ,
1653: p_token1_value => 'pa_conversion_date'
1654: );

Line 1651: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1647:
1648: IF (x_conversion_date is null) THEN
1649:
1650: OKE_API.set_message(p_app_name => G_APP_NAME ,
1651: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1652: p_token1 => 'VALUE' ,
1653: p_token1_value => 'pa_conversion_date'
1654: );
1655:

Line 1663: OKE_API.set_message(p_app_name => G_APP_NAME ,

1659:
1660: IF (upper(x_conversion_type) = 'USER') AND
1661: (x_conversion_rate is null) THEN
1662:
1663: OKE_API.set_message(p_app_name => G_APP_NAME ,
1664: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1665: p_token1 => 'VALUE' ,
1666: p_token1_value => 'pa_conversion_rate'
1667: );

Line 1664: p_msg_name => 'OKE_API_MISSING_VALUE' ,

1660: IF (upper(x_conversion_type) = 'USER') AND
1661: (x_conversion_rate is null) THEN
1662:
1663: OKE_API.set_message(p_app_name => G_APP_NAME ,
1664: p_msg_name => 'OKE_API_MISSING_VALUE' ,
1665: p_token1 => 'VALUE' ,
1666: p_token1_value => 'pa_conversion_rate'
1667: );
1668:

Line 1690: OKE_API.set_message(p_app_name => G_APP_NAME ,

1686: WHEN MISSING_ERROR THEN
1687: x_return_status := 'E';
1688:
1689: WHEN OTHERS THEN
1690: OKE_API.set_message(p_app_name => G_APP_NAME ,
1691: p_msg_name => G_UNEXPECTED_ERROR ,
1692: p_token1 => G_SQLCODE_TOKEN ,
1693: p_token1_value => SQLCODE ,
1694: p_token2 => G_SQLERRM_TOKEN ,