APPS.OKC_SCR_PVT dependencies on OKC_SCR_PVT

Line 1: PACKAGE BODY OKC_SCR_PVT AS

1: PACKAGE BODY OKC_SCR_PVT AS
2: /* $Header: OKCRSCRB.pls 120.0 2005/05/25 23:10:20 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: ---------------------------------------------------------------------------

Line 944: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,

940: EXCEPTION
941: -- other appropriate handlers
942: WHEN OTHERS THEN
943: -- store SQL error message on message stack
944: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
945: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
946: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
947: p_token1_value => sqlcode,
948: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,

Line 945: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,

941: -- other appropriate handlers
942: WHEN OTHERS THEN
943: -- store SQL error message on message stack
944: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
945: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
946: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
947: p_token1_value => sqlcode,
948: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
949: p_token2_value => sqlerrm);

Line 946: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,

942: WHEN OTHERS THEN
943: -- store SQL error message on message stack
944: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
945: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
946: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
947: p_token1_value => sqlcode,
948: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
949: p_token2_value => sqlerrm);
950:

Line 948: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,

944: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
945: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
946: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
947: p_token1_value => sqlcode,
948: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
949: p_token2_value => sqlerrm);
950:
951: -- notify UNEXPECTED error
952: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1011: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,

1007: EXCEPTION
1008: -- other appropriate handlers
1009: WHEN OTHERS THEN
1010: -- store SQL error message on message stack
1011: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
1012: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
1013: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
1014: p_token1_value => sqlcode,
1015: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,

Line 1012: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,

1008: -- other appropriate handlers
1009: WHEN OTHERS THEN
1010: -- store SQL error message on message stack
1011: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
1012: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
1013: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
1014: p_token1_value => sqlcode,
1015: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
1016: p_token2_value => sqlerrm);

Line 1013: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,

1009: WHEN OTHERS THEN
1010: -- store SQL error message on message stack
1011: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
1012: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
1013: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
1014: p_token1_value => sqlcode,
1015: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
1016: p_token2_value => sqlerrm);
1017:

Line 1015: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,

1011: OKC_API.SET_MESSAGE(p_app_name => okc_scr_pvt.G_APP_NAME,
1012: p_msg_name => okc_scr_pvt.G_UNEXPECTED_ERROR,
1013: p_token1 => okc_scr_pvt.G_SQLCODE_TOKEN,
1014: p_token1_value => sqlcode,
1015: p_token2 => okc_scr_pvt.G_SQLERRM_TOKEN,
1016: p_token2_value => sqlerrm);
1017:
1018: -- notify UNEXPECTED error
1019: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2331: END OKC_SCR_PVT;

2327: x_msg_data,
2328: '_PVT'
2329: );
2330: END delete_row;
2331: END OKC_SCR_PVT;