DBA Data[Home] [Help]

APPS.OKL_VP_STS_PVT dependencies on OKC_API

Line 7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3:
4:
5: PROCEDURE get_listof_new_statuses(
6: p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_ste_code IN VARCHAR2,

Line 81: OKC_API.SET_MESSAGE(

77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: NULL;
79: WHEN OTHERS THEN
80: -- store SQL error message on message stack
81: OKC_API.SET_MESSAGE(
82: p_app_name => G_APP_NAME,
83: p_msg_name => G_UNEXPECTED_ERROR,
84: p_token1 => G_SQLCODE_TOKEN,
85: p_token1_value => SQLCODE,

Line 89: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

85: p_token1_value => SQLCODE,
86: p_token2 => G_SQLERRM_TOKEN,
87: p_token2_value => SQLERRM);
88: -- notify caller of an error as UNEXPETED error
89: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
90:
91: IF cur_get_new_statuses%ISOPEN THEN
92: CLOSE cur_get_new_statuses;
93: END IF;

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

96:
97:
98: PROCEDURE change_agreement_status(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_chr_id IN NUMBER,

Line 144: OKC_API.set_message(p_app_name => g_app_name,

140: IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN
141:
142: l1_return_status :=OKL_API.G_RET_STS_ERROR;
143:
144: OKC_API.set_message(p_app_name => g_app_name,
145: p_msg_name => 'OKL_VP_UPDATE_NOT_ALLOWED'
146: );
147:
148: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 154: OKC_API.set_message(p_app_name => g_app_name,

150: END IF;
151: IF (p_new_sts_code NOT IN ('ABANDONED','PASSED','INCOMPLETE') OR
152: -- Manu 11-Jul-2005. Added Status INCOMPLETE --
153: (p_current_sts_code NOT IN ('NEW','PENDING','PASSED','INCOMPLETE'))) THEN
154: OKC_API.set_message(p_app_name => g_app_name,
155: p_msg_name => 'OKL_INVALID_CHANGE_STS'
156: );
157: RAISE OKL_API.G_EXCEPTION_ERROR;
158: ELSE

Line 177: OKC_API.set_message(p_app_name => g_app_name,

173: END IF;
174:
175: IF (OKL_VENDOR_PROGRAM_PUB.is_process_active(p_chr_id) <> 'N') THEN
176:
177: OKC_API.set_message(p_app_name => g_app_name,
178: p_msg_name => 'OKL_VP_APPROVAL_PROCESS_ACTV'
179: );
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: