APPS.OKC_SPLIT2_PAV_PVT dependencies on OKC_API

Line 233: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

229: p_chr_id IN NUMBER,
230: p_major_version IN NUMBER
231: ) RETURN VARCHAR2 IS
232:
233: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
234:
235: BEGIN
236: INSERT INTO okc_price_att_values
237: (

Line 908: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

904: EXCEPTION
905: -- other appropriate handlers
906: WHEN OTHERS THEN
907: -- store SQL error message on message stack
908: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
909: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
910: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
911: p_token1_value => sqlcode,
912: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 916: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

912: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
913: p_token2_value => sqlerrm);
914:
915: -- notify UNEXPECTED error
916: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
917: return l_return_status;
918: END restore_version;
919: ---------------------------------------------------------------
920: -- Procedure for mass insert in OKC_PRICE_ATT_VALUES _B and TL tables

Line 1146: x_return_status :=OKC_API.G_RET_STS_SUCCESS;

1142: i number;
1143: j number;
1144: BEGIN
1145: --Initialize return status
1146: x_return_status :=OKC_API.G_RET_STS_SUCCESS;
1147: i := p_pavv_tbl.FIRST; j:=0;
1148: while i is not null
1149: LOOP
1150: j:=j+1;

Line 1812: OKC_API.SET_MESSAGE(

1808:
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: -- store SQL error message on message stack
1812: OKC_API.SET_MESSAGE(
1813: p_app_name => G_APP_NAME,
1814: p_msg_name => G_UNEXPECTED_ERROR,
1815: p_token1 => G_SQLCODE_TOKEN,
1816: p_token1_value => SQLCODE,

Line 1820: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1816: p_token1_value => SQLCODE,
1817: p_token2 => G_SQLERRM_TOKEN,
1818: p_token2_value => SQLERRM);
1819: -- notify caller of an error as UNEXPECTED error
1820: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1821:
1822: RAISE;
1823: END INSERT_ROW_UPG;
1824: