APPS.OKL_FORMULAVALIDATE_PVT dependencies on OKL_API

Line 290: x_return_status := OKL_API.G_RET_STS_SUCCESS;

286: l_bRecursion BOOLEAN;
287:
288: l_Count NUMBER;
289: BEGIN
290: x_return_status := OKL_API.G_RET_STS_SUCCESS;
291:
292: /** SBALASHA001 -
293: INFO: Get all the formula operands for the given
294: formula identifier. **/

Line 304: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

300: IF ( l_bRecursion = TRUE )
301: THEN
302: /** SBALASHA001 -
303: INFO: Recursion exception **/
304: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
305: p_msg_name => G_FMA_RECURSION,
306: p_token1 => G_RECURSION_TOKEN,
307: p_token1_value => p_fma_id );
308: -- notify error for calling API

Line 309: x_return_status := OKL_API.G_RET_STS_ERROR;

305: p_msg_name => G_FMA_RECURSION,
306: p_token1 => G_RECURSION_TOKEN,
307: p_token1_value => p_fma_id );
308: -- notify error for calling API
309: x_return_status := OKL_API.G_RET_STS_ERROR;
310: -- notify error for calling API to override the regular exception handling.
311: x_validate_status := G_RET_STS_RECURSION_ERROR;
312: END IF;
313:

Line 315: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )

311: x_validate_status := G_RET_STS_RECURSION_ERROR;
312: END IF;
313:
314:
315: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )
316: THEN
317: /** SBALASHA001 -
318: INFO: Get all the context parameters for the
319: given formula. **/

Line 330: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

326: -- Commenting this as the validation is not necessary.
327: /*
328: IF ( l_ctx_parameter_tbl.count = 0 )
329: THEN
330: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
331: p_msg_name => G_CTX_GROUP_NOTFOUND,
332: p_token1 => G_CTX_GROUP_TOKEN,
333: p_token1_value => p_cgr_id );
334: -- notify error for calling API

Line 335: x_return_status := OKL_API.G_RET_STS_ERROR;

331: p_msg_name => G_CTX_GROUP_NOTFOUND,
332: p_token1 => G_CTX_GROUP_TOKEN,
333: p_token1_value => p_cgr_id );
334: -- notify error for calling API
335: x_return_status := OKL_API.G_RET_STS_ERROR;
336: END IF;
337: */
338:
339:

Line 340: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )

336: END IF;
337: */
338:
339:
340: IF ( x_return_status = OKL_API.G_RET_STS_SUCCESS )
341: THEN
342: /** SBALASHA001 -
343: INFO: Loop thru' the operand that are formula
344: and get all function parameters attached

Line 367: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

363: IF ( l_Match = FALSE )
364: THEN
365: /** SBALASHA001 -
366: INFO: Parameter mismatch exception. **/
367: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
368: p_msg_name => G_PRM_MISMATCH,
369: p_token1 => G_PRM_MISMATCH_TOKEN,
370: p_token1_value => p_fma_id );
371: -- notify error for calling API

Line 372: x_return_status := OKL_API.G_RET_STS_ERROR;

368: p_msg_name => G_PRM_MISMATCH,
369: p_token1 => G_PRM_MISMATCH_TOKEN,
370: p_token1_value => p_fma_id );
371: -- notify error for calling API
372: x_return_status := OKL_API.G_RET_STS_ERROR;
373: -- notify error for calling API to override the regular exception handling.
374: x_validate_status := G_RET_STS_PRM_MISMATCH_ERROR;
375: EXIT;
376: END IF;

Line 386: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

382: -- no processing necessary;
383: null;
384: WHEN OTHERS THEN
385: -- store SQL error message on message stack
386: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
387: p_msg_name => g_unexpected_error,
388: p_token1 => g_sqlcode_token,
389: p_token1_value => sqlcode,
390: p_token2 => g_sqlerrm_token,

Line 393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

389: p_token1_value => sqlcode,
390: p_token2 => g_sqlerrm_token,
391: p_token2_value => sqlerrm);
392: -- notify UNEXPECTED error for calling API.
393: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
394: END VAL_ValidateFormula;
395:
396:
397: