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_POPULATE_PRCENG_RST_PUB dependencies on OKL_SIF_RET_ERRORS

Line 1700: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V

1696:
1697:
1698:
1699: ---------------------------------------------------------------------------
1700: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V
1701: ---------------------------------------------------------------------------
1702:
1703: --Added by BKATRAGA on 03/03/2005
1704: --This procedure has been modified to accept a table of records instead of a

Line 1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1708: x_return_status OUT NOCOPY VARCHAR2,
1709: x_id OUT NOCOPY NUMBER,
1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:

Line 1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1709: x_id OUT NOCOPY NUMBER,
1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:
1717: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1710: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1711: p_strm_excp_tbl IN strm_excp_tbl_type,
1712: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1713: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1714: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1715: ) IS
1716:
1717: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1718: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;

1721: x_msg_data VARCHAR2(400);
1722: x_msg_count NUMBER ;
1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:

Line 1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;

1722: x_msg_count NUMBER ;
1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;

Line 1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;

1723: l_strm_excp_rec strm_excp_rec_type;
1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1731:

Line 1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;

1724: i NUMBER := 0;
1725: l_error_code OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR;
1726: l_error_message OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR;
1727: l_description OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR;
1728: l_tag_name OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR;
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1731:
1732: BEGIN

Line 1825: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V

1821: END populate_sif_ret_errors;
1822: --Bug - End of Changes
1823:
1824: ---------------------------------------------------------------------------
1825: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V
1826: ---------------------------------------------------------------------------
1827:
1828: PROCEDURE populate_sif_ret_errors (p_api_version IN NUMBER := 1.0,
1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

1829: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,

1830: x_return_status OUT NOCOPY VARCHAR2,
1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,

1831: x_id OUT NOCOPY NUMBER,
1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS

Line 1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1832: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1833: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1841: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1834: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1835: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1836: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1837: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1838: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1839: ) IS
1840: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1841: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1842: l_srmv_rec srmv_rec_type;

Line 1954: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V

1950: END populate_sif_ret_errors;
1951:
1952: -- mvasudev , 04/24/2002
1953: ---------------------------------------------------------------------------
1954: -- PROCEDURE populate_sif_ret_errors for: OKL_SIF_RET_ERRORS_V
1955: ---------------------------------------------------------------------------
1956:
1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,

Line 1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,

1956:
1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

Line 1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,

1957: PROCEDURE populate_sif_ret_errors (x_return_status OUT NOCOPY VARCHAR2,
1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

Line 1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,

1958: x_id OUT NOCOPY NUMBER,
1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS

Line 1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,

1959: p_sir_id IN NUMBER := OKC_API.G_MISS_NUM,
1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';

Line 1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,

1960: p_error_code IN OKL_SIF_RET_ERRORS.ERROR_CODE%TYPE := OKC_API.G_MISS_CHAR,
1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1968: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR

1961: p_error_message IN OKL_SIF_RET_ERRORS.ERROR_MESSAGE%TYPE := OKC_API.G_MISS_CHAR,
1962: p_tag_name IN OKL_SIF_RET_ERRORS.TAG_NAME%TYPE := OKC_API.G_MISS_CHAR,
1963: p_tag_attribute_name IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_NAME%TYPE := OKC_API.G_MISS_CHAR,
1964: p_tag_attribute_value IN OKL_SIF_RET_ERRORS.TAG_ATTRIBUTE_VALUE%TYPE := OKC_API.G_MISS_CHAR,
1965: p_description IN OKL_SIF_RET_ERRORS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
1966: ) IS
1967: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_ret_errors';
1968: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1969: l_srmv_rec srmv_rec_type;