9: --cklee:start
10: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
11: --cklee:end
12: -- sjalasut start
13: G_SUBSIDY_POOL_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ACTIVE';
14: G_SUBSIDY_POOL_EFFECTIVE_DATES CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_DATES_NO_OVERLAP';
15: --cklee 09/12/2005 G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LL_SUB_ATTACH_ASSET';
16: G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_ATTACH_ASSET';
17: -- sjalasut end
10: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
11: --cklee:end
12: -- sjalasut start
13: G_SUBSIDY_POOL_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ACTIVE';
14: G_SUBSIDY_POOL_EFFECTIVE_DATES CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_DATES_NO_OVERLAP';
15: --cklee 09/12/2005 G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LL_SUB_ATTACH_ASSET';
16: G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_ATTACH_ASSET';
17: -- sjalasut end
18:
11: --cklee:end
12: -- sjalasut start
13: G_SUBSIDY_POOL_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ACTIVE';
14: G_SUBSIDY_POOL_EFFECTIVE_DATES CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_DATES_NO_OVERLAP';
15: --cklee 09/12/2005 G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LL_SUB_ATTACH_ASSET';
16: G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_ATTACH_ASSET';
17: -- sjalasut end
18:
19: --cklee:start 07/22/05
12: -- sjalasut start
13: G_SUBSIDY_POOL_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ACTIVE';
14: G_SUBSIDY_POOL_EFFECTIVE_DATES CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_DATES_NO_OVERLAP';
15: --cklee 09/12/2005 G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LL_SUB_ATTACH_ASSET';
16: G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_ATTACH_ASSET';
17: -- sjalasut end
18:
19: --cklee:start 07/22/05
20: G_SUBSIDY_POOL_ASSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSOC_STATUS';
16: G_SUBSIDY_ATTACH_ASSET_EXIST CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_ATTACH_ASSET';
17: -- sjalasut end
18:
19: --cklee:start 07/22/05
20: G_SUBSIDY_POOL_ASSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSOC_STATUS';
21: G_SUBSIDY_POOL_DISSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISSOC_STATUS';
22: G_SUBSIDY_POOL_ASSOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSC_EXP_POOL';
23: G_SUBSIDY_POOL_DISOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISC_EXP_POOL';
24: --cklee:end 07/22/05
17: -- sjalasut end
18:
19: --cklee:start 07/22/05
20: G_SUBSIDY_POOL_ASSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSOC_STATUS';
21: G_SUBSIDY_POOL_DISSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISSOC_STATUS';
22: G_SUBSIDY_POOL_ASSOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSC_EXP_POOL';
23: G_SUBSIDY_POOL_DISOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISC_EXP_POOL';
24: --cklee:end 07/22/05
25:
18:
19: --cklee:start 07/22/05
20: G_SUBSIDY_POOL_ASSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSOC_STATUS';
21: G_SUBSIDY_POOL_DISSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISSOC_STATUS';
22: G_SUBSIDY_POOL_ASSOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSC_EXP_POOL';
23: G_SUBSIDY_POOL_DISOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISC_EXP_POOL';
24: --cklee:end 07/22/05
25:
26: ---------------------------------------------------------------------------
19: --cklee:start 07/22/05
20: G_SUBSIDY_POOL_ASSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSOC_STATUS';
21: G_SUBSIDY_POOL_DISSOC_STATUS CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISSOC_STATUS';
22: G_SUBSIDY_POOL_ASSOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_ASSC_EXP_POOL';
23: G_SUBSIDY_POOL_DISOC_EXP_POOL CONSTANT fnd_new_messages.message_name%TYPE := 'OKL_LLA_SUB_POOL_DISC_EXP_POOL';
24: --cklee:end 07/22/05
25:
26: ---------------------------------------------------------------------------
27: -- PROCEDURE load_error_tbl