[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 = Done! yn=3; allowed-values=1
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! 3=nullable; 1=notnull (currency)
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! 25
118: ) ;
119: x_return_status := OKL_Api.G_RET_STS_ERROR;
120: RAISE G_EXCEPTION_HALT_VALIDATION;
121: ELSE
122: x_return_status := OKL_UTIL.CHECK_ORG_ID(p_tapv_rec.org_id);
123: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
124: OKL_Api.SET_MESSAGE
125: ( p_app_name => g_app_name,
126: p_msg_name => g_invalid_value,
266: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
267: BEGIN
268: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
269: IF(p_tapv_rec.wait_vendor_invoice_yn IS NOT NULL) THEN
270: x_return_status := OKL_UTIL.CHECK_DOMAIN_YN(p_tapv_rec.wait_vendor_invoice_yn);
271: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
272: OKL_Api.SET_MESSAGE
273: ( p_app_name => g_app_name,
274: p_msg_name => g_invalid_value,
304: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
305: BEGIN
306: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
307: IF(p_tapv_rec.consolidate_yn IS NOT NULL) THEN
308: x_return_status := OKL_UTIL.CHECK_DOMAIN_YN(p_tapv_rec.consolidate_yn);
309: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
310: OKL_Api.SET_MESSAGE
311: ( p_app_name => g_app_name,
312: p_msg_name => g_invalid_value,
342: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
343: BEGIN
344: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
345: IF(p_tapv_rec.workflow_yn IS NOT NULL) THEN
346: x_return_status := OKL_UTIL.CHECK_DOMAIN_YN(p_tapv_rec.workflow_yn);
347: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
348: OKL_Api.SET_MESSAGE
349: ( p_app_name => g_app_name,
350: p_msg_name => g_invalid_value,
380: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
381: BEGIN
382: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
383: IF(p_tapv_rec.payment_method_code IS NOT NULL) THEN
384: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
385: ( 'OKL_AP_PAYMENT_METHOD'
386: , p_tapv_rec.payment_method_code
387: );
388: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
421: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
422: BEGIN
423: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
424: IF(p_tapv_rec.invoice_category_code IS NOT NULL) THEN
425: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
426: ( 'OKL_AP_INVOICE_CATEGORY'
427: , p_tapv_rec.invoice_category_code
428: );
429: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
523: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
524: BEGIN
525: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
526: IF(p_tapv_rec.funding_type_code IS NOT NULL) THEN
527: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
528: ( 'OKL_FUNDING_TYPE'
529: , p_tapv_rec.funding_type_code
530: );
531: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN
1534: ) ;
1535: x_return_status := OKL_Api.G_RET_STS_ERROR;
1536: RAISE G_EXCEPTION_HALT_VALIDATION;
1537: END IF;
1538: x_return_status := OKL_UTIL.CHECK_LOOKUP_CODE
1539: ( 'OKL_TRANSACTION_STATUS'
1540: , p_tapv_rec.trx_status_code
1541: );
1542: IF x_return_status <> OKL_Api.G_RET_STS_SUCCESS THEN