[Home] [Help]
12: -- 4. Validity of Unique Keys = N/A, No Unique Keys
13: -- 5. Validity of Org_id = Done
14: -- 6. Added domain validation = N/A, No Domain Values Used
15: -- 7. Added the Concurrent Manager Columns (p104) = Done 2=views:v_insert_row,v_update_row
16: -- 8. Validate fnd_lookup code using OKL_UTIL pkg = Done 2 1=not-null, 1=nullable
17: -- 9. Capture most severe error in loops (p103) = Done 5 loops (except l_lang_rec)
18: --10. Reduce use of SYSDATE fill_who_columns (p104) = Done 1 (for insert)
19: --11. Fix Migrate Parameter p_to IN OUT (p104) = Done 4
20: --12. Call validate procs. in Validate_Attributes = Done 14
89: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
90: BEGIN
91: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
92: IF(p_tplv_rec.taxable_yn IS NOT NULL) THEN
93: x_return_status := OKL_UTIL.CHECK_DOMAIN_YN(p_tplv_rec.taxable_yn);
94: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
95: OKL_Api.SET_MESSAGE
96: ( p_app_name => g_app_name,
97: p_msg_name => g_invalid_value,
194: RAISE G_EXCEPTION_HALT_VALIDATION;
195:
196: ELSE
197:
198: x_return_status := OKL_UTIL.CHECK_ORG_ID(p_tplv_rec.org_id);
199:
200: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
201:
202: OKL_Api.SET_MESSAGE
310: RAISE G_EXCEPTION_HALT_VALIDATION;
311:
312: END IF;
313:
314: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
315: ( 'OKL_AP_DISTR_LINE_TYPE'
316: , p_tplv_rec.inv_distr_line_code
317: );
318: */
365: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
366:
367: IF(p_tplv_rec.disbursement_basis_code IS NOT NULL) THEN
368:
369: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
370: ( 'OKL_DISBURSEMENT_BASIS'
371: , p_tplv_rec.disbursement_basis_code
372: );
373:
422: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
423:
424: IF(p_tplv_rec.funding_reference_type_code IS NOT NULL) THEN
425:
426: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
427: ( 'OKL_FUNDING_REFERENCE_TYPE'
428: , p_tplv_rec.funding_reference_type_code
429: );
430: