APPS.OKS_RENEW_UTIL_PVT dependencies on OKC_API

Line 31: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

27:
28: RETURN l_return;
29: EXCEPTION
30: WHEN OTHERS THEN
31: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
32: p_msg_name => g_unexpected_error,
33: p_token1 => g_sqlcode_token,
34: p_token1_value => SQLCODE,
35: p_token2 => g_sqlerrm_token,

Line 65: l_return_status := OKC_API.G_RET_STS_SUCCESS;

61: e_error EXCEPTION;
62:
63: BEGIN
64:
65: l_return_status := OKC_API.G_RET_STS_SUCCESS;
66:
67: l_khdr_rec_in.chr_id := p_chr_id;
68: l_khdr_rec_in.renewal_status := p_renew_status;
69:

Line 81: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

77: x_khrv_rec => l_khdr_rec_out,
78: p_validate_yn => 'N'
79: );
80:
81: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
82: RAISE e_Error;
83: END IF;
84:
85: l_okc_hdr_rec_in.id := p_chr_id;

Line 99: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN

95: p_chrv_rec => l_okc_hdr_rec_in,
96: x_chrv_rec => l_okc_hdr_rec_out
97: );
98:
99: IF NOT l_return_status = OKC_API.G_RET_STS_SUCCESS THEN
100: RAISE e_Error;
101: END IF;
102:
103: EXCEPTION

Line 108: OKC_API.SET_MESSAGE(

104: WHEN E_Error THEN
105: x_Return_status := l_Return_status;
106: WHEN OTHERS THEN
107: -- store SQL error message on message stack for caller
108: OKC_API.SET_MESSAGE(
109: p_app_name => g_app_name,
110: p_msg_name => g_unexpected_error,
111: p_token1 => g_sqlcode_token,
112: p_token1_value => SQLCODE,

Line 118: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

114: p_token2_value => SQLERRM
115: );
116:
117: -- notify caller of an UNEXPECTED error
118: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
119: END;
120:
121: PROCEDURE get_payment_terms (
122: p_chr_id IN NUMBER,

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

128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2) IS
131:
132: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
133: l_payment_terms_id1 VARCHAR2(40);
134: l_payment_terms_id2 VARCHAR2(40);
135: l_payment_term_flag VARCHAR2(1) := 'N';
136: l_msg_count NUMBER;

Line 187: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,

183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)
184: ) THEN
185:
186: IF p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM THEN
187: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
188: 'TOKEN1', 'CHR_ID',
189: 'TOKEN2', 'GET_PAYMENT_TERMS');
190: END IF;
191:

Line 193: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,

189: 'TOKEN2', 'GET_PAYMENT_TERMS');
190: END IF;
191:
192: IF p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM THEN
193: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
194: 'TOKEN1', 'PARTY_ID',
195: 'TOKEN2', 'GET_PAYMENT_TERMS');
196: END IF;
197:

Line 199: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,

195: 'TOKEN2', 'GET_PAYMENT_TERMS');
196: END IF;
197:
198: IF p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM THEN
199: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
200: 'TOKEN1', 'ORG_ID',
201: 'TOKEN2', 'GET_PAYMENT_TERMS');
202: END IF;
203:

Line 204: l_Return_Status := OKC_API.G_RET_STS_ERROR;

200: 'TOKEN1', 'ORG_ID',
201: 'TOKEN2', 'GET_PAYMENT_TERMS');
202: END IF;
203:
204: l_Return_Status := OKC_API.G_RET_STS_ERROR;
205: RAISE G_EXCEPTION_HALT_VALIDATION;
206:
207: END IF;
208:

Line 263: OKC_API.set_message(G_APP_NAME, 'OKS_GLOBAL_DEFAULTS_NOT_FOUND');

259: -- As there should be always values under globals in
260: -- global defaults setup, if nothing is found, raise error
261: IF l_global_level_cur%NOTFOUND THEN
262: CLOSE l_global_level_cur;
263: OKC_API.set_message(G_APP_NAME, 'OKS_GLOBAL_DEFAULTS_NOT_FOUND');
264: l_return_status := OKC_API.G_RET_STS_ERROR;
265: RAISE G_EXCEPTION_HALT_VALIDATION;
266: END IF;
267: CLOSE l_global_level_cur;

Line 264: l_return_status := OKC_API.G_RET_STS_ERROR;

260: -- global defaults setup, if nothing is found, raise error
261: IF l_global_level_cur%NOTFOUND THEN
262: CLOSE l_global_level_cur;
263: OKC_API.set_message(G_APP_NAME, 'OKS_GLOBAL_DEFAULTS_NOT_FOUND');
264: l_return_status := OKC_API.G_RET_STS_ERROR;
265: RAISE G_EXCEPTION_HALT_VALIDATION;
266: END IF;
267: CLOSE l_global_level_cur;
268: END IF;

Line 280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
277: x_return_status := l_return_status;
278: WHEN OTHERS THEN
279: -- store SQL error message on message stack for caller
280: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
281: p_msg_name => g_unexpected_error,
282: p_token1 => g_sqlcode_token,
283: p_token1_value => SQLCODE,
284: p_token2 => g_sqlerrm_token,

Line 288: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

284: p_token2 => g_sqlerrm_token,
285: p_token2_value => SQLERRM);
286:
287: -- notify caller of an UNEXPECTED error
288: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
289: END get_payment_terms;
290:
291: PROCEDURE Can_Update_Contract(
292: p_chr_id IN NUMBER,

Line 301: x_return_status := OKC_API.G_RET_STS_SUCCESS;

297: x_return_status OUT NOCOPY VARCHAR2
298: ) IS
299:
300: BEGIN
301: x_return_status := OKC_API.G_RET_STS_SUCCESS;
302: x_can_update_yn := 'Y';
303: x_can_submit_yn := 'Y';
304: END Can_Update_Contract;
305:

Line 343: x_return_status := OKC_API.G_RET_STS_SUCCESS;

339: l_period_start oks_k_defaults.period_start%TYPE;
340: l_price_uom oks_k_defaults.price_uom%TYPE;
341:
342: BEGIN
343: x_return_status := OKC_API.G_RET_STS_SUCCESS;
344: IF p_hdr_id IS NOT NULL
345: THEN
346: OPEN get_hdr_period_val(p_hdr_id);
347: FETCH get_hdr_period_val INTO l_period_type, l_period_start, l_price_uom;

Line 387: x_return_status := OKC_API.G_RET_STS_ERROR;

383: END IF;
384:
385: EXCEPTION
386: WHEN OTHERS THEN
387: x_return_status := OKC_API.G_RET_STS_ERROR;
388:
389: END get_period_defaults;
390:
391: /*