DBA Data[Home] [Help]

APPS.OKL_PA_DATA_INTEGRITY dependencies on OKL_PA_DATA_INTEGRITY

Line 1: PACKAGE BODY OKL_PA_DATA_INTEGRITY AS

1: PACKAGE BODY OKL_PA_DATA_INTEGRITY AS
2: /* $Header: OKLRPAQB.pls 120.11 2007/11/21 08:38:54 rgooty noship $ */
3:
4: G_TOT_RESIDU_INC_MSG CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INCORRECT_RESIDUAL';
5: G_RESIDU_NOT_POS_MSG CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INCORRECT_PERCENT';

Line 134: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_date_overlap';

130:
131: l_return_value VARCHAR2(1) ;
132: lv_dummy VARCHAR2(1);
133:
134: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_date_overlap';
135: l_debug_enabled VARCHAR2(10);
136:
137: BEGIN
138: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 236: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_end_date';

232:
233:
234: l_return_value VARCHAR2(1) ;
235:
236: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_end_date';
237: l_debug_enabled VARCHAR2(10);
238:
239: BEGIN
240:

Line 286: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_start_date';

282: FUNCTION validate_start_date(p_assoc_start_date IN DATE, p_agrmnt_start_date IN DATE, p_agrmnt_end_date IN DATE) RETURN VARCHAR2 IS
283:
284: l_return_value VARCHAR2(1) ;
285:
286: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_start_date';
287: l_debug_enabled VARCHAR2(10);
288:
289: BEGIN
290:

Line 328: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_status';

324: FUNCTION validate_status(p_status IN VARCHAR2) RETURN VARCHAR2 IS
325:
326: l_return_value VARCHAR2(1) ;
327:
328: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_status';
329: l_debug_enabled VARCHAR2(10);
330:
331: BEGIN
332:

Line 370: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.get_lookup_meaning';

366: AND FND.LOOKUP_CODE = p_lookup_code;
367:
368: l_return_value fnd_lookups.meaning%TYPE;
369:
370: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.get_lookup_meaning';
371: l_debug_enabled VARCHAR2(10);
372:
373: BEGIN
374: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 620: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.check_functional_constraints';

616: p_api_version NUMBER;
617: p_init_msg_list VARCHAR2(256) DEFAULT OKC_API.G_FALSE;
618: x_msg_count NUMBER;
619: x_msg_data VARCHAR2(256);
620: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.check_functional_constraints';
621: l_debug_enabled VARCHAR2(10);
622:
623: l_dummy VARCHAR2(1);
624: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE

Line 1118: END OKL_PA_DATA_INTEGRITY;

1114: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1115:
1116: END check_functional_constraints;
1117:
1118: END OKL_PA_DATA_INTEGRITY;