eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VFA_PVT dependencies on OKL_API

Line 6: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_API.G_CHILD_TABLE_TOKEN';

2: /* $Header: OKLSVFAB.pls 120.3 2006/11/13 07:37:41 dpsingh noship $ */
3:
4: /************************ HAND-CODED *********************************/
5: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
6: G_TABLE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_API.G_CHILD_TABLE_TOKEN';
7: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
8: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
9: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
10: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';

Line 37: x_return_status := OKL_API.G_RET_STS_SUCCESS;

33: FROM okc_k_headers_b
34: WHERE id = p_dnz_chr_id);
35: BEGIN
36: -- initialize return status
37: x_return_status := OKL_API.G_RET_STS_SUCCESS;
38: -- data is required
39: IF (p_dnz_chr_id = OKL_API.G_MISS_NUM) OR
40: (p_dnz_chr_id IS NULL) THEN
41: -- halt validation as it is a required field

Line 39: IF (p_dnz_chr_id = OKL_API.G_MISS_NUM) OR

35: BEGIN
36: -- initialize return status
37: x_return_status := OKL_API.G_RET_STS_SUCCESS;
38: -- data is required
39: IF (p_dnz_chr_id = OKL_API.G_MISS_NUM) OR
40: (p_dnz_chr_id IS NULL) THEN
41: -- halt validation as it is a required field
42: RAISE G_EXCEPTION_STOP_VALIDATION;
43: END IF;

Line 59: OKL_API.set_message(p_app_name => G_APP_NAME,

55: EXCEPTION
56: WHEN G_EXCEPTION_STOP_VALIDATION then
57: -- We are here since the field is required
58: -- store SQL error message on message stack
59: OKL_API.set_message(p_app_name => G_APP_NAME,
60: p_msg_name => G_REQUIRED_VALUE,
61: p_token1 => G_COL_NAME_TOKEN,
62: p_token1_value => 'dnz_chr_id');
63: -- Notify Error

Line 64: x_return_status := OKL_API.G_RET_STS_ERROR;

60: p_msg_name => G_REQUIRED_VALUE,
61: p_token1 => G_COL_NAME_TOKEN,
62: p_token1_value => 'dnz_chr_id');
63: -- Notify Error
64: x_return_status := OKL_API.G_RET_STS_ERROR;
65: WHEN G_EXCEPTION_HALT_VALIDATION then
66: -- We are here b'cause we have no parent record
67: -- store SQL error message on message stack
68: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 68: OKL_API.set_message(p_app_name => G_APP_NAME,

64: x_return_status := OKL_API.G_RET_STS_ERROR;
65: WHEN G_EXCEPTION_HALT_VALIDATION then
66: -- We are here b'cause we have no parent record
67: -- store SQL error message on message stack
68: OKL_API.set_message(p_app_name => G_APP_NAME,
69: p_msg_name => G_NO_MATCHING_RECORD,
70: p_token1 => G_COL_NAME_TOKEN,
71: p_token1_value => 'dnz_chr_id');
72: -- If the cursor is open then it has to be closed

Line 77: x_return_status := OKL_API.G_RET_STS_ERROR;

73: IF c_dnz_chr_id_validate%ISOPEN THEN
74: CLOSE c_dnz_chr_id_validate;
75: END IF;
76: -- notify caller of an error
77: x_return_status := OKL_API.G_RET_STS_ERROR;
78: WHEN OTHERS THEN
79: -- store SQL error message on message stack
80: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
81: p_msg_name => G_UNEXPECTED_ERROR,

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

76: -- notify caller of an error
77: x_return_status := OKL_API.G_RET_STS_ERROR;
78: WHEN OTHERS THEN
79: -- store SQL error message on message stack
80: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
81: p_msg_name => G_UNEXPECTED_ERROR,
82: p_token1 => G_SQLCODE_TOKEN,
83: p_token1_value => SQLCODE,
84: p_token2 => G_SQLERRM_TOKEN,

Line 91: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

87: IF c_dnz_chr_id_validate%ISOPEN THEN
88: CLOSE c_dnz_chr_id_validate;
89: END IF;
90: -- notify caller of an error as UNEXPETED error
91: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
92: END validate_dnz_chr_id;
93: ---------------------------------------------------------------------------------
94: -- Start of Commnets
95: -- Badrinath Kuchibholta

Line 136: x_return_status := OKL_API.G_RET_STS_SUCCESS;

132:
133:
134: BEGIN
135: -- initialize return status
136: x_return_status := OKL_API.G_RET_STS_SUCCESS;
137: -- data is required
138: IF (p_id = OKL_API.G_MISS_NUM) OR
139: (p_id IS NULL) THEN
140: -- halt validation as it is a required field

Line 138: IF (p_id = OKL_API.G_MISS_NUM) OR

134: BEGIN
135: -- initialize return status
136: x_return_status := OKL_API.G_RET_STS_SUCCESS;
137: -- data is required
138: IF (p_id = OKL_API.G_MISS_NUM) OR
139: (p_id IS NULL) THEN
140: -- halt validation as it is a required field
141: RAISE G_EXCEPTION_STOP_VALIDATION;
142: END IF;

Line 173: OKL_API.set_message(p_app_name => G_APP_NAME,

169: EXCEPTION
170: WHEN G_EXCEPTION_STOP_VALIDATION then
171: -- We are here since the field is required
172: -- store SQL error message on message stack
173: OKL_API.set_message(p_app_name => G_APP_NAME,
174: p_msg_name => G_REQUIRED_VALUE,
175: p_token1 => G_COL_NAME_TOKEN,
176: p_token1_value => 'fa_cle_id');
177: -- Notify Error

Line 178: x_return_status := OKL_API.G_RET_STS_ERROR;

174: p_msg_name => G_REQUIRED_VALUE,
175: p_token1 => G_COL_NAME_TOKEN,
176: p_token1_value => 'fa_cle_id');
177: -- Notify Error
178: x_return_status := OKL_API.G_RET_STS_ERROR;
179: WHEN G_EXCEPTION_HALT_VALIDATION then
180: -- We are here b'cause we have no parent record
181: -- store SQL error message on message stack
182: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 182: OKL_API.set_message(p_app_name => G_APP_NAME,

178: x_return_status := OKL_API.G_RET_STS_ERROR;
179: WHEN G_EXCEPTION_HALT_VALIDATION then
180: -- We are here b'cause we have no parent record
181: -- store SQL error message on message stack
182: OKL_API.set_message(p_app_name => G_APP_NAME,
183: p_msg_name => G_NO_MATCHING_RECORD,
184: p_token1 => G_COL_NAME_TOKEN,
185: p_token1_value => 'fa_cle_id');
186: -- If the cursor is open then it has to be closed

Line 194: x_return_status := OKL_API.G_RET_STS_ERROR;

190: IF c_cle_id_validate1%ISOPEN THEN
191: CLOSE c_cle_id_validate1;
192: END IF;
193: -- notify caller of an error
194: x_return_status := OKL_API.G_RET_STS_ERROR;
195: WHEN OTHERS THEN
196: -- store SQL error message on message stack
197: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
198: p_msg_name => G_UNEXPECTED_ERROR,

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

193: -- notify caller of an error
194: x_return_status := OKL_API.G_RET_STS_ERROR;
195: WHEN OTHERS THEN
196: -- store SQL error message on message stack
197: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
198: p_msg_name => G_UNEXPECTED_ERROR,
199: p_token1 => G_SQLCODE_TOKEN,
200: p_token1_value => SQLCODE,
201: p_token2 => G_SQLERRM_TOKEN,

Line 211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

207: IF c_cle_id_validate1%ISOPEN THEN
208: CLOSE c_cle_id_validate1;
209: END IF;
210: -- notify caller of an error as UNEXPETED error
211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
212: END validate_fa_cle_id;
213:
214: -- Added by dpsingh
215: ---------------------------------------------------------------------------

Line 236: IF (p_legal_entity_id = OKL_API.G_MISS_NUM OR

232:
233: BEGIN
234:
235: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
236: IF (p_legal_entity_id = OKL_API.G_MISS_NUM OR
237: p_legal_entity_id IS NULL)
238: THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'legal_entity_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'legal_entity_id');

235: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
236: IF (p_legal_entity_id = OKL_API.G_MISS_NUM OR
237: p_legal_entity_id IS NULL)
238: THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'legal_entity_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: ELSIF (p_legal_entity_id IS NOT NULL) AND
242: (p_legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
243: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id) ;

Line 240: x_return_status := OKL_API.G_RET_STS_ERROR;

236: IF (p_legal_entity_id = OKL_API.G_MISS_NUM OR
237: p_legal_entity_id IS NULL)
238: THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'legal_entity_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: ELSIF (p_legal_entity_id IS NOT NULL) AND
242: (p_legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
243: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id) ;
244: IF (l_exists<>1) THEN

Line 242: (p_legal_entity_id <> Okl_Api.G_MISS_NUM) THEN

238: THEN
239: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'legal_entity_id');
240: x_return_status := OKL_API.G_RET_STS_ERROR;
241: ELSIF (p_legal_entity_id IS NOT NULL) AND
242: (p_legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
243: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id) ;
244: IF (l_exists<>1) THEN
245: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
246: RAISE item_not_found_error;

Line 245: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

241: ELSIF (p_legal_entity_id IS NOT NULL) AND
242: (p_legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
243: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_legal_entity_id) ;
244: IF (l_exists<>1) THEN
245: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
246: RAISE item_not_found_error;
247: END IF;
248: END IF;
249:

Line 445: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

441: x_return_status OUT NOCOPY VARCHAR2
442: ) RETURN vfav_rec_type IS
443: l_vfav_rec vfav_rec_type;
444: l_row_notfound BOOLEAN := TRUE;
445: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
446: BEGIN
447: l_vfav_rec := get_rec(p_vfav_rec, l_row_notfound);
448: IF (l_row_notfound) THEN
449: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 449: x_return_status := OKL_API.G_RET_STS_ERROR;

445: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
446: BEGIN
447: l_vfav_rec := get_rec(p_vfav_rec, l_row_notfound);
448: IF (l_row_notfound) THEN
449: x_return_status := OKL_API.G_RET_STS_ERROR;
450: END IF;
451: x_return_status:= l_return_status;
452: RETURN(l_vfav_rec);
453: END get_rec;

Line 608: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

604: x_return_status OUT NOCOPY VARCHAR2
605: ) RETURN vfa_rec_type IS
606: l_vfa_rec vfa_rec_type;
607: l_row_notfound BOOLEAN := TRUE;
608: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
609: BEGIN
610: l_vfa_rec := get_rec(p_vfa_rec, l_row_notfound);
611: IF (l_row_notfound) THEN
612: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 612: x_return_status := OKL_API.G_RET_STS_ERROR;

608: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
609: BEGIN
610: l_vfa_rec := get_rec(p_vfa_rec, l_row_notfound);
611: IF (l_row_notfound) THEN
612: x_return_status := OKL_API.G_RET_STS_ERROR;
613: END IF;
614: x_return_status := l_return_status;
615: RETURN(l_vfa_rec);
616: END get_rec;

Line 635: IF (l_vfav_rec.id = OKL_API.G_MISS_NUM ) THEN

631: p_vfav_rec IN vfav_rec_type
632: ) RETURN vfav_rec_type IS
633: l_vfav_rec vfav_rec_type := p_vfav_rec;
634: BEGIN
635: IF (l_vfav_rec.id = OKL_API.G_MISS_NUM ) THEN
636: l_vfav_rec.id := NULL;
637: END IF;
638: IF (l_vfav_rec.major_version = OKL_API.G_MISS_NUM ) THEN
639: l_vfav_rec.major_version := NULL;

Line 638: IF (l_vfav_rec.major_version = OKL_API.G_MISS_NUM ) THEN

634: BEGIN
635: IF (l_vfav_rec.id = OKL_API.G_MISS_NUM ) THEN
636: l_vfav_rec.id := NULL;
637: END IF;
638: IF (l_vfav_rec.major_version = OKL_API.G_MISS_NUM ) THEN
639: l_vfav_rec.major_version := NULL;
640: END IF;
641: IF (l_vfav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
642: l_vfav_rec.object_version_number := NULL;

Line 641: IF (l_vfav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

637: END IF;
638: IF (l_vfav_rec.major_version = OKL_API.G_MISS_NUM ) THEN
639: l_vfav_rec.major_version := NULL;
640: END IF;
641: IF (l_vfav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
642: l_vfav_rec.object_version_number := NULL;
643: END IF;
644: IF (l_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM ) THEN
645: l_vfav_rec.dnz_chr_id := NULL;

Line 644: IF (l_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM ) THEN

640: END IF;
641: IF (l_vfav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
642: l_vfav_rec.object_version_number := NULL;
643: END IF;
644: IF (l_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM ) THEN
645: l_vfav_rec.dnz_chr_id := NULL;
646: END IF;
647: IF (l_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM ) THEN
648: l_vfav_rec.fa_cle_id := NULL;

Line 647: IF (l_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM ) THEN

643: END IF;
644: IF (l_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM ) THEN
645: l_vfav_rec.dnz_chr_id := NULL;
646: END IF;
647: IF (l_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM ) THEN
648: l_vfav_rec.fa_cle_id := NULL;
649: END IF;
650: IF (l_vfav_rec.name = OKL_API.G_MISS_CHAR ) THEN
651: l_vfav_rec.name := NULL;

Line 650: IF (l_vfav_rec.name = OKL_API.G_MISS_CHAR ) THEN

646: END IF;
647: IF (l_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM ) THEN
648: l_vfav_rec.fa_cle_id := NULL;
649: END IF;
650: IF (l_vfav_rec.name = OKL_API.G_MISS_CHAR ) THEN
651: l_vfav_rec.name := NULL;
652: END IF;
653: IF (l_vfav_rec.description = OKL_API.G_MISS_CHAR ) THEN
654: l_vfav_rec.description := NULL;

Line 653: IF (l_vfav_rec.description = OKL_API.G_MISS_CHAR ) THEN

649: END IF;
650: IF (l_vfav_rec.name = OKL_API.G_MISS_CHAR ) THEN
651: l_vfav_rec.name := NULL;
652: END IF;
653: IF (l_vfav_rec.description = OKL_API.G_MISS_CHAR ) THEN
654: l_vfav_rec.description := NULL;
655: END IF;
656: IF (l_vfav_rec.asset_id = OKL_API.G_MISS_NUM ) THEN
657: l_vfav_rec.asset_id := NULL;

Line 656: IF (l_vfav_rec.asset_id = OKL_API.G_MISS_NUM ) THEN

652: END IF;
653: IF (l_vfav_rec.description = OKL_API.G_MISS_CHAR ) THEN
654: l_vfav_rec.description := NULL;
655: END IF;
656: IF (l_vfav_rec.asset_id = OKL_API.G_MISS_NUM ) THEN
657: l_vfav_rec.asset_id := NULL;
658: END IF;
659: IF (l_vfav_rec.asset_number = OKL_API.G_MISS_CHAR ) THEN
660: l_vfav_rec.asset_number := NULL;

Line 659: IF (l_vfav_rec.asset_number = OKL_API.G_MISS_CHAR ) THEN

655: END IF;
656: IF (l_vfav_rec.asset_id = OKL_API.G_MISS_NUM ) THEN
657: l_vfav_rec.asset_id := NULL;
658: END IF;
659: IF (l_vfav_rec.asset_number = OKL_API.G_MISS_CHAR ) THEN
660: l_vfav_rec.asset_number := NULL;
661: END IF;
662: IF (l_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR ) THEN
663: l_vfav_rec.corporate_book := NULL;

Line 662: IF (l_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR ) THEN

658: END IF;
659: IF (l_vfav_rec.asset_number = OKL_API.G_MISS_CHAR ) THEN
660: l_vfav_rec.asset_number := NULL;
661: END IF;
662: IF (l_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR ) THEN
663: l_vfav_rec.corporate_book := NULL;
664: END IF;
665: IF (l_vfav_rec.life_in_months = OKL_API.G_MISS_NUM ) THEN
666: l_vfav_rec.life_in_months := NULL;

Line 665: IF (l_vfav_rec.life_in_months = OKL_API.G_MISS_NUM ) THEN

661: END IF;
662: IF (l_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR ) THEN
663: l_vfav_rec.corporate_book := NULL;
664: END IF;
665: IF (l_vfav_rec.life_in_months = OKL_API.G_MISS_NUM ) THEN
666: l_vfav_rec.life_in_months := NULL;
667: END IF;
668: IF (l_vfav_rec.original_cost = OKL_API.G_MISS_NUM ) THEN
669: l_vfav_rec.original_cost := NULL;

Line 668: IF (l_vfav_rec.original_cost = OKL_API.G_MISS_NUM ) THEN

664: END IF;
665: IF (l_vfav_rec.life_in_months = OKL_API.G_MISS_NUM ) THEN
666: l_vfav_rec.life_in_months := NULL;
667: END IF;
668: IF (l_vfav_rec.original_cost = OKL_API.G_MISS_NUM ) THEN
669: l_vfav_rec.original_cost := NULL;
670: END IF;
671: IF (l_vfav_rec.cost = OKL_API.G_MISS_NUM ) THEN
672: l_vfav_rec.cost := NULL;

Line 671: IF (l_vfav_rec.cost = OKL_API.G_MISS_NUM ) THEN

667: END IF;
668: IF (l_vfav_rec.original_cost = OKL_API.G_MISS_NUM ) THEN
669: l_vfav_rec.original_cost := NULL;
670: END IF;
671: IF (l_vfav_rec.cost = OKL_API.G_MISS_NUM ) THEN
672: l_vfav_rec.cost := NULL;
673: END IF;
674: IF (l_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM ) THEN
675: l_vfav_rec.adjusted_cost := NULL;

Line 674: IF (l_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM ) THEN

670: END IF;
671: IF (l_vfav_rec.cost = OKL_API.G_MISS_NUM ) THEN
672: l_vfav_rec.cost := NULL;
673: END IF;
674: IF (l_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM ) THEN
675: l_vfav_rec.adjusted_cost := NULL;
676: END IF;
677: IF (l_vfav_rec.current_units = OKL_API.G_MISS_NUM ) THEN
678: l_vfav_rec.current_units := NULL;

Line 677: IF (l_vfav_rec.current_units = OKL_API.G_MISS_NUM ) THEN

673: END IF;
674: IF (l_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM ) THEN
675: l_vfav_rec.adjusted_cost := NULL;
676: END IF;
677: IF (l_vfav_rec.current_units = OKL_API.G_MISS_NUM ) THEN
678: l_vfav_rec.current_units := NULL;
679: END IF;
680: IF (l_vfav_rec.new_used = OKL_API.G_MISS_CHAR ) THEN
681: l_vfav_rec.new_used := NULL;

Line 680: IF (l_vfav_rec.new_used = OKL_API.G_MISS_CHAR ) THEN

676: END IF;
677: IF (l_vfav_rec.current_units = OKL_API.G_MISS_NUM ) THEN
678: l_vfav_rec.current_units := NULL;
679: END IF;
680: IF (l_vfav_rec.new_used = OKL_API.G_MISS_CHAR ) THEN
681: l_vfav_rec.new_used := NULL;
682: END IF;
683: IF (l_vfav_rec.in_service_date = OKL_API.G_MISS_DATE ) THEN
684: l_vfav_rec.in_service_date := NULL;

Line 683: IF (l_vfav_rec.in_service_date = OKL_API.G_MISS_DATE ) THEN

679: END IF;
680: IF (l_vfav_rec.new_used = OKL_API.G_MISS_CHAR ) THEN
681: l_vfav_rec.new_used := NULL;
682: END IF;
683: IF (l_vfav_rec.in_service_date = OKL_API.G_MISS_DATE ) THEN
684: l_vfav_rec.in_service_date := NULL;
685: END IF;
686: IF (l_vfav_rec.model_number = OKL_API.G_MISS_CHAR ) THEN
687: l_vfav_rec.model_number := NULL;

Line 686: IF (l_vfav_rec.model_number = OKL_API.G_MISS_CHAR ) THEN

682: END IF;
683: IF (l_vfav_rec.in_service_date = OKL_API.G_MISS_DATE ) THEN
684: l_vfav_rec.in_service_date := NULL;
685: END IF;
686: IF (l_vfav_rec.model_number = OKL_API.G_MISS_CHAR ) THEN
687: l_vfav_rec.model_number := NULL;
688: END IF;
689: IF (l_vfav_rec.asset_type = OKL_API.G_MISS_CHAR ) THEN
690: l_vfav_rec.asset_type := NULL;

Line 689: IF (l_vfav_rec.asset_type = OKL_API.G_MISS_CHAR ) THEN

685: END IF;
686: IF (l_vfav_rec.model_number = OKL_API.G_MISS_CHAR ) THEN
687: l_vfav_rec.model_number := NULL;
688: END IF;
689: IF (l_vfav_rec.asset_type = OKL_API.G_MISS_CHAR ) THEN
690: l_vfav_rec.asset_type := NULL;
691: END IF;
692: IF (l_vfav_rec.salvage_value = OKL_API.G_MISS_NUM ) THEN
693: l_vfav_rec.salvage_value := NULL;

Line 692: IF (l_vfav_rec.salvage_value = OKL_API.G_MISS_NUM ) THEN

688: END IF;
689: IF (l_vfav_rec.asset_type = OKL_API.G_MISS_CHAR ) THEN
690: l_vfav_rec.asset_type := NULL;
691: END IF;
692: IF (l_vfav_rec.salvage_value = OKL_API.G_MISS_NUM ) THEN
693: l_vfav_rec.salvage_value := NULL;
694: END IF;
695: IF (l_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM ) THEN
696: l_vfav_rec.percent_salvage_value := NULL;

Line 695: IF (l_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM ) THEN

691: END IF;
692: IF (l_vfav_rec.salvage_value = OKL_API.G_MISS_NUM ) THEN
693: l_vfav_rec.salvage_value := NULL;
694: END IF;
695: IF (l_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM ) THEN
696: l_vfav_rec.percent_salvage_value := NULL;
697: END IF;
698: IF (l_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM ) THEN
699: l_vfav_rec.depreciation_category := NULL;

Line 698: IF (l_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM ) THEN

694: END IF;
695: IF (l_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM ) THEN
696: l_vfav_rec.percent_salvage_value := NULL;
697: END IF;
698: IF (l_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM ) THEN
699: l_vfav_rec.depreciation_category := NULL;
700: END IF;
701: IF (l_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE ) THEN
702: l_vfav_rec.deprn_start_date := NULL;

Line 701: IF (l_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE ) THEN

697: END IF;
698: IF (l_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM ) THEN
699: l_vfav_rec.depreciation_category := NULL;
700: END IF;
701: IF (l_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE ) THEN
702: l_vfav_rec.deprn_start_date := NULL;
703: END IF;
704: IF (l_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR ) THEN
705: l_vfav_rec.deprn_method_code := NULL;

Line 704: IF (l_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR ) THEN

700: END IF;
701: IF (l_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE ) THEN
702: l_vfav_rec.deprn_start_date := NULL;
703: END IF;
704: IF (l_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR ) THEN
705: l_vfav_rec.deprn_method_code := NULL;
706: END IF;
707: IF (l_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM ) THEN
708: l_vfav_rec.rate_adjustment_factor := NULL;

Line 707: IF (l_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM ) THEN

703: END IF;
704: IF (l_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR ) THEN
705: l_vfav_rec.deprn_method_code := NULL;
706: END IF;
707: IF (l_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM ) THEN
708: l_vfav_rec.rate_adjustment_factor := NULL;
709: END IF;
710: IF (l_vfav_rec.basic_rate = OKL_API.G_MISS_NUM ) THEN
711: l_vfav_rec.basic_rate := NULL;

Line 710: IF (l_vfav_rec.basic_rate = OKL_API.G_MISS_NUM ) THEN

706: END IF;
707: IF (l_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM ) THEN
708: l_vfav_rec.rate_adjustment_factor := NULL;
709: END IF;
710: IF (l_vfav_rec.basic_rate = OKL_API.G_MISS_NUM ) THEN
711: l_vfav_rec.basic_rate := NULL;
712: END IF;
713: IF (l_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM ) THEN
714: l_vfav_rec.adjusted_rate := NULL;

Line 713: IF (l_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM ) THEN

709: END IF;
710: IF (l_vfav_rec.basic_rate = OKL_API.G_MISS_NUM ) THEN
711: l_vfav_rec.basic_rate := NULL;
712: END IF;
713: IF (l_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM ) THEN
714: l_vfav_rec.adjusted_rate := NULL;
715: END IF;
716: IF (l_vfav_rec.start_date_active = OKL_API.G_MISS_DATE ) THEN
717: l_vfav_rec.start_date_active := NULL;

Line 716: IF (l_vfav_rec.start_date_active = OKL_API.G_MISS_DATE ) THEN

712: END IF;
713: IF (l_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM ) THEN
714: l_vfav_rec.adjusted_rate := NULL;
715: END IF;
716: IF (l_vfav_rec.start_date_active = OKL_API.G_MISS_DATE ) THEN
717: l_vfav_rec.start_date_active := NULL;
718: END IF;
719: IF (l_vfav_rec.end_date_active = OKL_API.G_MISS_DATE ) THEN
720: l_vfav_rec.end_date_active := NULL;

Line 719: IF (l_vfav_rec.end_date_active = OKL_API.G_MISS_DATE ) THEN

715: END IF;
716: IF (l_vfav_rec.start_date_active = OKL_API.G_MISS_DATE ) THEN
717: l_vfav_rec.start_date_active := NULL;
718: END IF;
719: IF (l_vfav_rec.end_date_active = OKL_API.G_MISS_DATE ) THEN
720: l_vfav_rec.end_date_active := NULL;
721: END IF;
722: IF (l_vfav_rec.status = OKL_API.G_MISS_CHAR ) THEN
723: l_vfav_rec.status := NULL;

Line 722: IF (l_vfav_rec.status = OKL_API.G_MISS_CHAR ) THEN

718: END IF;
719: IF (l_vfav_rec.end_date_active = OKL_API.G_MISS_DATE ) THEN
720: l_vfav_rec.end_date_active := NULL;
721: END IF;
722: IF (l_vfav_rec.status = OKL_API.G_MISS_CHAR ) THEN
723: l_vfav_rec.status := NULL;
724: END IF;
725: IF (l_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR ) THEN
726: l_vfav_rec.primary_uom_code := NULL;

Line 725: IF (l_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR ) THEN

721: END IF;
722: IF (l_vfav_rec.status = OKL_API.G_MISS_CHAR ) THEN
723: l_vfav_rec.status := NULL;
724: END IF;
725: IF (l_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR ) THEN
726: l_vfav_rec.primary_uom_code := NULL;
727: END IF;
728: IF (l_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM ) THEN
729: l_vfav_rec.recoverable_cost := NULL;

Line 728: IF (l_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM ) THEN

724: END IF;
725: IF (l_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR ) THEN
726: l_vfav_rec.primary_uom_code := NULL;
727: END IF;
728: IF (l_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM ) THEN
729: l_vfav_rec.recoverable_cost := NULL;
730: END IF;
731: --Bug# 2981308:
732: IF (l_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM ) THEN

Line 732: IF (l_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM ) THEN

728: IF (l_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM ) THEN
729: l_vfav_rec.recoverable_cost := NULL;
730: END IF;
731: --Bug# 2981308:
732: IF (l_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM ) THEN
733: l_vfav_rec.asset_key_id := NULL;
734: END IF;
735: IF (l_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
736: l_vfav_rec.attribute_category := NULL;

Line 735: IF (l_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

731: --Bug# 2981308:
732: IF (l_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM ) THEN
733: l_vfav_rec.asset_key_id := NULL;
734: END IF;
735: IF (l_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
736: l_vfav_rec.attribute_category := NULL;
737: END IF;
738: IF (l_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
739: l_vfav_rec.attribute1 := NULL;

Line 738: IF (l_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

734: END IF;
735: IF (l_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
736: l_vfav_rec.attribute_category := NULL;
737: END IF;
738: IF (l_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
739: l_vfav_rec.attribute1 := NULL;
740: END IF;
741: IF (l_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
742: l_vfav_rec.attribute2 := NULL;

Line 741: IF (l_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

737: END IF;
738: IF (l_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
739: l_vfav_rec.attribute1 := NULL;
740: END IF;
741: IF (l_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
742: l_vfav_rec.attribute2 := NULL;
743: END IF;
744: IF (l_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
745: l_vfav_rec.attribute3 := NULL;

Line 744: IF (l_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

740: END IF;
741: IF (l_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
742: l_vfav_rec.attribute2 := NULL;
743: END IF;
744: IF (l_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
745: l_vfav_rec.attribute3 := NULL;
746: END IF;
747: IF (l_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
748: l_vfav_rec.attribute4 := NULL;

Line 747: IF (l_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

743: END IF;
744: IF (l_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
745: l_vfav_rec.attribute3 := NULL;
746: END IF;
747: IF (l_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
748: l_vfav_rec.attribute4 := NULL;
749: END IF;
750: IF (l_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
751: l_vfav_rec.attribute5 := NULL;

Line 750: IF (l_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

746: END IF;
747: IF (l_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
748: l_vfav_rec.attribute4 := NULL;
749: END IF;
750: IF (l_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
751: l_vfav_rec.attribute5 := NULL;
752: END IF;
753: IF (l_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
754: l_vfav_rec.attribute6 := NULL;

Line 753: IF (l_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

749: END IF;
750: IF (l_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
751: l_vfav_rec.attribute5 := NULL;
752: END IF;
753: IF (l_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
754: l_vfav_rec.attribute6 := NULL;
755: END IF;
756: IF (l_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
757: l_vfav_rec.attribute7 := NULL;

Line 756: IF (l_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

752: END IF;
753: IF (l_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
754: l_vfav_rec.attribute6 := NULL;
755: END IF;
756: IF (l_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
757: l_vfav_rec.attribute7 := NULL;
758: END IF;
759: IF (l_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
760: l_vfav_rec.attribute8 := NULL;

Line 759: IF (l_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

755: END IF;
756: IF (l_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
757: l_vfav_rec.attribute7 := NULL;
758: END IF;
759: IF (l_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
760: l_vfav_rec.attribute8 := NULL;
761: END IF;
762: IF (l_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
763: l_vfav_rec.attribute9 := NULL;

Line 762: IF (l_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

758: END IF;
759: IF (l_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
760: l_vfav_rec.attribute8 := NULL;
761: END IF;
762: IF (l_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
763: l_vfav_rec.attribute9 := NULL;
764: END IF;
765: IF (l_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
766: l_vfav_rec.attribute10 := NULL;

Line 765: IF (l_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

761: END IF;
762: IF (l_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
763: l_vfav_rec.attribute9 := NULL;
764: END IF;
765: IF (l_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
766: l_vfav_rec.attribute10 := NULL;
767: END IF;
768: IF (l_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
769: l_vfav_rec.attribute11 := NULL;

Line 768: IF (l_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

764: END IF;
765: IF (l_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
766: l_vfav_rec.attribute10 := NULL;
767: END IF;
768: IF (l_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
769: l_vfav_rec.attribute11 := NULL;
770: END IF;
771: IF (l_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
772: l_vfav_rec.attribute12 := NULL;

Line 771: IF (l_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

767: END IF;
768: IF (l_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
769: l_vfav_rec.attribute11 := NULL;
770: END IF;
771: IF (l_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
772: l_vfav_rec.attribute12 := NULL;
773: END IF;
774: IF (l_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
775: l_vfav_rec.attribute13 := NULL;

Line 774: IF (l_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

770: END IF;
771: IF (l_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
772: l_vfav_rec.attribute12 := NULL;
773: END IF;
774: IF (l_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
775: l_vfav_rec.attribute13 := NULL;
776: END IF;
777: IF (l_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
778: l_vfav_rec.attribute14 := NULL;

Line 777: IF (l_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

773: END IF;
774: IF (l_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
775: l_vfav_rec.attribute13 := NULL;
776: END IF;
777: IF (l_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
778: l_vfav_rec.attribute14 := NULL;
779: END IF;
780: IF (l_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
781: l_vfav_rec.attribute15 := NULL;

Line 780: IF (l_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

776: END IF;
777: IF (l_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
778: l_vfav_rec.attribute14 := NULL;
779: END IF;
780: IF (l_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
781: l_vfav_rec.attribute15 := NULL;
782: END IF;
783: IF (l_vfav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
784: l_vfav_rec.created_by := NULL;

Line 783: IF (l_vfav_rec.created_by = OKL_API.G_MISS_NUM ) THEN

779: END IF;
780: IF (l_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
781: l_vfav_rec.attribute15 := NULL;
782: END IF;
783: IF (l_vfav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
784: l_vfav_rec.created_by := NULL;
785: END IF;
786: IF (l_vfav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
787: l_vfav_rec.creation_date := NULL;

Line 786: IF (l_vfav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

782: END IF;
783: IF (l_vfav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
784: l_vfav_rec.created_by := NULL;
785: END IF;
786: IF (l_vfav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
787: l_vfav_rec.creation_date := NULL;
788: END IF;
789: IF (l_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
790: l_vfav_rec.last_updated_by := NULL;

Line 789: IF (l_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

785: END IF;
786: IF (l_vfav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
787: l_vfav_rec.creation_date := NULL;
788: END IF;
789: IF (l_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
790: l_vfav_rec.last_updated_by := NULL;
791: END IF;
792: IF (l_vfav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
793: l_vfav_rec.last_update_date := NULL;

Line 792: IF (l_vfav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

788: END IF;
789: IF (l_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
790: l_vfav_rec.last_updated_by := NULL;
791: END IF;
792: IF (l_vfav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
793: l_vfav_rec.last_update_date := NULL;
794: END IF;
795: IF (l_vfav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
796: l_vfav_rec.last_update_login := NULL;

Line 795: IF (l_vfav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

791: END IF;
792: IF (l_vfav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
793: l_vfav_rec.last_update_date := NULL;
794: END IF;
795: IF (l_vfav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
796: l_vfav_rec.last_update_login := NULL;
797: END IF;
798: --Added by dpsingh for LE uptake
799: IF (l_vfav_rec.legal_entity_id = OKL_API.G_MISS_NUM ) THEN

Line 799: IF (l_vfav_rec.legal_entity_id = OKL_API.G_MISS_NUM ) THEN

795: IF (l_vfav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
796: l_vfav_rec.last_update_login := NULL;
797: END IF;
798: --Added by dpsingh for LE uptake
799: IF (l_vfav_rec.legal_entity_id = OKL_API.G_MISS_NUM ) THEN
800: l_vfav_rec.legal_entity_id := NULL;
801: END IF;
802: RETURN(l_vfav_rec);
803: END null_out_defaults;

Line 813: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

809: ---------------------------------------------------
810: FUNCTION Validate_Attributes (
811: p_vfav_rec IN vfav_rec_type
812: ) RETURN VARCHAR2 IS
813: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
814: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
815: BEGIN
816: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
817: OKC_UTIL.ADD_VIEW('OKL_CONTRACT_ASSET_HV', x_return_status);

Line 814: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

810: FUNCTION Validate_Attributes (
811: p_vfav_rec IN vfav_rec_type
812: ) RETURN VARCHAR2 IS
813: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
814: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
815: BEGIN
816: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
817: OKC_UTIL.ADD_VIEW('OKL_CONTRACT_ASSET_HV', x_return_status);
818: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 818: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

814: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
815: BEGIN
816: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
817: OKC_UTIL.ADD_VIEW('OKL_CONTRACT_ASSET_HV', x_return_status);
818: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
819: l_return_status := x_return_status;
820: END IF;
821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR
822: p_vfav_rec.id IS NULL THEN

Line 821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR

817: OKC_UTIL.ADD_VIEW('OKL_CONTRACT_ASSET_HV', x_return_status);
818: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
819: l_return_status := x_return_status;
820: END IF;
821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR
822: p_vfav_rec.id IS NULL THEN
823: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
824: x_return_status := OKL_API.G_RET_STS_ERROR;
825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 823: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

819: l_return_status := x_return_status;
820: END IF;
821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR
822: p_vfav_rec.id IS NULL THEN
823: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
824: x_return_status := OKL_API.G_RET_STS_ERROR;
825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
826: l_return_status := x_return_status;
827: END IF;

Line 824: x_return_status := OKL_API.G_RET_STS_ERROR;

820: END IF;
821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR
822: p_vfav_rec.id IS NULL THEN
823: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
824: x_return_status := OKL_API.G_RET_STS_ERROR;
825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
826: l_return_status := x_return_status;
827: END IF;
828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR

Line 825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

821: IF p_vfav_rec.id = OKL_API.G_MISS_NUM OR
822: p_vfav_rec.id IS NULL THEN
823: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
824: x_return_status := OKL_API.G_RET_STS_ERROR;
825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
826: l_return_status := x_return_status;
827: END IF;
828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR
829: p_vfav_rec.major_version IS NULL THEN

Line 828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR

824: x_return_status := OKL_API.G_RET_STS_ERROR;
825: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
826: l_return_status := x_return_status;
827: END IF;
828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR
829: p_vfav_rec.major_version IS NULL THEN
830: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'major_version');
831: x_return_status := OKL_API.G_RET_STS_ERROR;
832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 830: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'major_version');

826: l_return_status := x_return_status;
827: END IF;
828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR
829: p_vfav_rec.major_version IS NULL THEN
830: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'major_version');
831: x_return_status := OKL_API.G_RET_STS_ERROR;
832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
833: l_return_status := x_return_status;
834: END IF;

Line 831: x_return_status := OKL_API.G_RET_STS_ERROR;

827: END IF;
828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR
829: p_vfav_rec.major_version IS NULL THEN
830: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'major_version');
831: x_return_status := OKL_API.G_RET_STS_ERROR;
832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
833: l_return_status := x_return_status;
834: END IF;
835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR

Line 832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

828: ELSIF p_vfav_rec.major_version = OKL_API.G_MISS_NUM OR
829: p_vfav_rec.major_version IS NULL THEN
830: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'major_version');
831: x_return_status := OKL_API.G_RET_STS_ERROR;
832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
833: l_return_status := x_return_status;
834: END IF;
835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR
836: p_vfav_rec.object_version_number IS NULL THEN

Line 835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR

831: x_return_status := OKL_API.G_RET_STS_ERROR;
832: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
833: l_return_status := x_return_status;
834: END IF;
835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR
836: p_vfav_rec.object_version_number IS NULL THEN
837: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
838: x_return_status := OKL_API.G_RET_STS_ERROR;
839: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 837: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

833: l_return_status := x_return_status;
834: END IF;
835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR
836: p_vfav_rec.object_version_number IS NULL THEN
837: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
838: x_return_status := OKL_API.G_RET_STS_ERROR;
839: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
840: l_return_status := x_return_status;
841: END IF;

Line 838: x_return_status := OKL_API.G_RET_STS_ERROR;

834: END IF;
835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR
836: p_vfav_rec.object_version_number IS NULL THEN
837: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
838: x_return_status := OKL_API.G_RET_STS_ERROR;
839: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
840: l_return_status := x_return_status;
841: END IF;
842: END IF;

Line 839: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

835: ELSIF p_vfav_rec.object_version_number = OKL_API.G_MISS_NUM OR
836: p_vfav_rec.object_version_number IS NULL THEN
837: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
838: x_return_status := OKL_API.G_RET_STS_ERROR;
839: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
840: l_return_status := x_return_status;
841: END IF;
842: END IF;
843: --*******************************Hand Code ***********************************--

Line 845: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

841: END IF;
842: END IF;
843: --*******************************Hand Code ***********************************--
844: validate_dnz_chr_id(x_return_status, p_vfav_rec.dnz_chr_id);
845: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
846: l_return_status := x_return_status;
847: END IF;
848: validate_fa_cle_id(x_return_status, p_vfav_rec.fa_cle_id);
849: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 849: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

845: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
846: l_return_status := x_return_status;
847: END IF;
848: validate_fa_cle_id(x_return_status, p_vfav_rec.fa_cle_id);
849: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
850: l_return_status := x_return_status;
851: END IF;
852:
853: --Added by dpsingh

Line 857: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

853: --Added by dpsingh
854:
855: -- Validate_LE_Id
856: Validate_LE_Id(p_vfav_rec.legal_entity_id, x_return_status);
857: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
858: l_return_status := x_return_status;
859: END IF;
860: --*******************************Hand Code ***********************************--
861: RETURN(l_return_status);

Line 864: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

860: --*******************************Hand Code ***********************************--
861: RETURN(l_return_status);
862: EXCEPTION
863: WHEN OTHERS THEN
864: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
865: ,p_msg_name => G_UNEXPECTED_ERROR
866: ,p_token1 => G_SQLCODE_TOKEN
867: ,p_token1_value => SQLCODE
868: ,p_token2 => G_SQLERRM_TOKEN

Line 870: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

866: ,p_token1 => G_SQLCODE_TOKEN
867: ,p_token1_value => SQLCODE
868: ,p_token2 => G_SQLERRM_TOKEN
869: ,p_token2_value => SQLERRM);
870: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
871: RETURN(l_return_status);
872: END Validate_Attributes;
873: ---------------------------------------------------------------------------
874: -- PROCEDURE Validate_Record

Line 881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

877: -- Validate Record for:OKL_CONTRACT_ASSET_HV --
878: -----------------------------------------------
879: FUNCTION Validate_Record (p_vfav_rec IN vfav_rec_type)
880: RETURN VARCHAR2 IS
881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
882: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
883: BEGIN
884: RETURN (l_return_status);
885: EXCEPTION

Line 882: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

878: -----------------------------------------------
879: FUNCTION Validate_Record (p_vfav_rec IN vfav_rec_type)
880: RETURN VARCHAR2 IS
881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
882: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
883: BEGIN
884: RETURN (l_return_status);
885: EXCEPTION
886: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 889: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

885: EXCEPTION
886: WHEN G_EXCEPTION_HALT_VALIDATION THEN
887: RETURN(l_return_status);
888: WHEN OTHERS THEN
889: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
890: ,p_msg_name => G_UNEXPECTED_ERROR
891: ,p_token1 => G_SQLCODE_TOKEN
892: ,p_token1_value => SQLCODE
893: ,p_token2 => G_SQLERRM_TOKEN

Line 895: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

891: ,p_token1 => G_SQLCODE_TOKEN
892: ,p_token1_value => SQLCODE
893: ,p_token2 => G_SQLERRM_TOKEN
894: ,p_token2_value => SQLERRM);
895: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
896: RETURN(l_return_status);
897: END Validate_Record;
898: ---------------------------------------------------------------------------
899: -- PROCEDURE Migrate

Line 1035: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1031: -- validate_row for:OKL_CONTRACT_ASSET_HV --
1032: --------------------------------------------
1033: PROCEDURE validate_row(
1034: p_api_version IN NUMBER,
1035: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1036: x_return_status OUT NOCOPY VARCHAR2,
1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2,
1039: p_vfav_rec IN vfav_rec_type) IS

Line 1043: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1039: p_vfav_rec IN vfav_rec_type) IS
1040:
1041: l_api_version CONSTANT NUMBER := 1;
1042: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1043: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1044: l_vfav_rec vfav_rec_type := p_vfav_rec;
1045: l_vfa_rec vfa_rec_type;
1046: BEGIN
1047: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1047: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1043: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1044: l_vfav_rec vfav_rec_type := p_vfav_rec;
1045: l_vfa_rec vfa_rec_type;
1046: BEGIN
1047: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1048: G_PKG_NAME,
1049: p_init_msg_list,
1050: l_api_version,
1051: p_api_version,

Line 1054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1050: l_api_version,
1051: p_api_version,
1052: '_PVT',
1053: x_return_status);
1054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;

Line 1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1051: p_api_version,
1052: '_PVT',
1053: x_return_status);
1054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059: --- Validate all non-missing attributes (Item Level Validation)

Line 1056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1052: '_PVT',
1053: x_return_status);
1054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059: --- Validate all non-missing attributes (Item Level Validation)
1060: l_return_status := Validate_Attributes(l_vfav_rec);

Line 1057: RAISE OKL_API.G_EXCEPTION_ERROR;

1053: x_return_status);
1054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059: --- Validate all non-missing attributes (Item Level Validation)
1060: l_return_status := Validate_Attributes(l_vfav_rec);
1061: --- If any errors happen abort API

Line 1062: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1058: END IF;
1059: --- Validate all non-missing attributes (Item Level Validation)
1060: l_return_status := Validate_Attributes(l_vfav_rec);
1061: --- If any errors happen abort API
1062: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;

Line 1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1059: --- Validate all non-missing attributes (Item Level Validation)
1060: l_return_status := Validate_Attributes(l_vfav_rec);
1061: --- If any errors happen abort API
1062: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);

Line 1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1060: l_return_status := Validate_Attributes(l_vfav_rec);
1061: --- If any errors happen abort API
1062: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1065: RAISE OKL_API.G_EXCEPTION_ERROR;

1061: --- If any errors happen abort API
1062: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1064: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_ERROR;
1072: END IF;

Line 1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1065: RAISE OKL_API.G_EXCEPTION_ERROR;
1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: x_return_status := l_return_status;

Line 1070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1066: END IF;
1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: x_return_status := l_return_status;
1074: EXCEPTION

Line 1071: RAISE OKL_API.G_EXCEPTION_ERROR;

1067: l_return_status := Validate_Record(l_vfav_rec);
1068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: x_return_status := l_return_status;
1074: EXCEPTION
1075: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1075: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1071: RAISE OKL_API.G_EXCEPTION_ERROR;
1072: END IF;
1073: x_return_status := l_return_status;
1074: EXCEPTION
1075: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1077: (
1078: l_api_name,
1079: G_PKG_NAME,

Line 1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1072: END IF;
1073: x_return_status := l_return_status;
1074: EXCEPTION
1075: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1077: (
1078: l_api_name,
1079: G_PKG_NAME,
1080: 'OKL_API.G_RET_STS_ERROR',

Line 1080: 'OKL_API.G_RET_STS_ERROR',

1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1077: (
1078: l_api_name,
1079: G_PKG_NAME,
1080: 'OKL_API.G_RET_STS_ERROR',
1081: x_msg_count,
1082: x_msg_data,
1083: '_PVT'
1084: );

Line 1085: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1081: x_msg_count,
1082: x_msg_data,
1083: '_PVT'
1084: );
1085: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1087: (
1088: l_api_name,
1089: G_PKG_NAME,

Line 1086: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1082: x_msg_data,
1083: '_PVT'
1084: );
1085: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1087: (
1088: l_api_name,
1089: G_PKG_NAME,
1090: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1090: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1087: (
1088: l_api_name,
1089: G_PKG_NAME,
1090: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1091: x_msg_count,
1092: x_msg_data,
1093: '_PVT'
1094: );

Line 1096: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1092: x_msg_data,
1093: '_PVT'
1094: );
1095: WHEN OTHERS THEN
1096: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1097: (
1098: l_api_name,
1099: G_PKG_NAME,
1100: 'OTHERS',

Line 1111: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1107: -- PL/SQL TBL validate_row for:OKL_CONTRACT_ASSET_HV --
1108: -------------------------------------------------------
1109: PROCEDURE validate_row(
1110: p_api_version IN NUMBER,
1111: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1112: x_return_status OUT NOCOPY VARCHAR2,
1113: x_msg_count OUT NOCOPY NUMBER,
1114: x_msg_data OUT NOCOPY VARCHAR2,
1115: p_vfav_tbl IN vfav_tbl_type) IS

Line 1121: OKL_API.init_msg_list(p_init_msg_list);

1117: l_api_version CONSTANT NUMBER := 1;
1118: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1119: i NUMBER := 0;
1120: BEGIN
1121: OKL_API.init_msg_list(p_init_msg_list);
1122: -- Make sure PL/SQL table has records in it before passing
1123: IF (p_vfav_tbl.COUNT > 0) THEN
1124: i := p_vfav_tbl.FIRST;
1125: LOOP

Line 1137: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1133: EXIT WHEN (i = p_vfav_tbl.LAST);
1134: i := p_vfav_tbl.NEXT(i);
1135: END LOOP;
1136: END IF;
1137: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1138: EXCEPTION
1139: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1141: (

Line 1139: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1135: END LOOP;
1136: END IF;
1137: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1138: EXCEPTION
1139: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1141: (
1142: l_api_name,
1143: G_PKG_NAME,

Line 1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1136: END IF;
1137: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1138: EXCEPTION
1139: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1141: (
1142: l_api_name,
1143: G_PKG_NAME,
1144: 'OKL_API.G_RET_STS_ERROR',

Line 1144: 'OKL_API.G_RET_STS_ERROR',

1140: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1141: (
1142: l_api_name,
1143: G_PKG_NAME,
1144: 'OKL_API.G_RET_STS_ERROR',
1145: x_msg_count,
1146: x_msg_data,
1147: '_PVT'
1148: );

Line 1149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1145: x_msg_count,
1146: x_msg_data,
1147: '_PVT'
1148: );
1149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1150: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1151: (
1152: l_api_name,
1153: G_PKG_NAME,

Line 1150: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1146: x_msg_data,
1147: '_PVT'
1148: );
1149: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1150: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1151: (
1152: l_api_name,
1153: G_PKG_NAME,
1154: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1154: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1150: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1151: (
1152: l_api_name,
1153: G_PKG_NAME,
1154: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1155: x_msg_count,
1156: x_msg_data,
1157: '_PVT'
1158: );

Line 1160: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1156: x_msg_data,
1157: '_PVT'
1158: );
1159: WHEN OTHERS THEN
1160: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1161: (
1162: l_api_name,
1163: G_PKG_NAME,
1164: 'OTHERS',

Line 1177: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1173: ------------------------------------------
1174: -- insert_row for:OKL_CONTRACT_ASSET_HV --
1175: ------------------------------------------
1176: PROCEDURE insert_row(
1177: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1178: x_return_status OUT NOCOPY VARCHAR2,
1179: x_msg_count OUT NOCOPY NUMBER,
1180: x_msg_data OUT NOCOPY VARCHAR2,
1181: p_vfa_rec IN vfa_rec_type,

Line 1186: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1182: x_vfa_rec OUT NOCOPY vfa_rec_type) IS
1183:
1184: l_api_version CONSTANT NUMBER := 1;
1185: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1186: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1187: l_vfa_rec vfa_rec_type := p_vfa_rec;
1188: l_def_vfa_rec vfa_rec_type;
1189: ----------------------------------------------
1190: -- Set_Attributes for:OKL_CONTRACT_ASSET_HV --

Line 1196: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1192: FUNCTION Set_Attributes (
1193: p_vfa_rec IN vfa_rec_type,
1194: x_vfa_rec OUT NOCOPY vfa_rec_type
1195: ) RETURN VARCHAR2 IS
1196: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1197: BEGIN
1198: x_vfa_rec := p_vfa_rec;
1199: RETURN(l_return_status);
1200: END Set_Attributes;

Line 1202: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1198: x_vfa_rec := p_vfa_rec;
1199: RETURN(l_return_status);
1200: END Set_Attributes;
1201: BEGIN
1202: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1203: p_init_msg_list,
1204: '_PVT',
1205: x_return_status);
1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1202: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1203: p_init_msg_list,
1204: '_PVT',
1205: x_return_status);
1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;

Line 1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1203: p_init_msg_list,
1204: '_PVT',
1205: x_return_status);
1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211: --- Setting item atributes

Line 1208: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1204: '_PVT',
1205: x_return_status);
1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211: --- Setting item atributes
1212: l_return_status := Set_Attributes(

Line 1209: RAISE OKL_API.G_EXCEPTION_ERROR;

1205: x_return_status);
1206: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211: --- Setting item atributes
1212: l_return_status := Set_Attributes(
1213: p_vfa_rec, -- IN

Line 1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1212: l_return_status := Set_Attributes(
1213: p_vfa_rec, -- IN
1214: l_vfa_rec); -- OUT
1215: --- If any errors happen abort API
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;

Line 1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1213: p_vfa_rec, -- IN
1214: l_vfa_rec); -- OUT
1215: --- If any errors happen abort API
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221: INSERT INTO OKL_CONTRACT_ASSET_H(

Line 1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1214: l_vfa_rec); -- OUT
1215: --- If any errors happen abort API
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221: INSERT INTO OKL_CONTRACT_ASSET_H(
1222: id,

Line 1219: RAISE OKL_API.G_EXCEPTION_ERROR;

1215: --- If any errors happen abort API
1216: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1219: RAISE OKL_API.G_EXCEPTION_ERROR;
1220: END IF;
1221: INSERT INTO OKL_CONTRACT_ASSET_H(
1222: id,
1223: major_version,

Line 1340: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1336: l_vfa_rec.legal_entity_id);
1337: -- Set OUT values
1338: x_vfa_rec := l_vfa_rec;
1339: x_return_status := l_return_status;
1340: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1341: EXCEPTION
1342: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1343: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1344: (

Line 1342: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1338: x_vfa_rec := l_vfa_rec;
1339: x_return_status := l_return_status;
1340: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1341: EXCEPTION
1342: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1343: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,

Line 1343: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1339: x_return_status := l_return_status;
1340: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1341: EXCEPTION
1342: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1343: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,
1347: 'OKL_API.G_RET_STS_ERROR',

Line 1347: 'OKL_API.G_RET_STS_ERROR',

1343: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1344: (
1345: l_api_name,
1346: G_PKG_NAME,
1347: 'OKL_API.G_RET_STS_ERROR',
1348: x_msg_count,
1349: x_msg_data,
1350: '_PVT'
1351: );

Line 1352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1348: x_msg_count,
1349: x_msg_data,
1350: '_PVT'
1351: );
1352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1353: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1354: (
1355: l_api_name,
1356: G_PKG_NAME,

Line 1353: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1349: x_msg_data,
1350: '_PVT'
1351: );
1352: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1353: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1354: (
1355: l_api_name,
1356: G_PKG_NAME,
1357: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1357: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1353: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1354: (
1355: l_api_name,
1356: G_PKG_NAME,
1357: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1358: x_msg_count,
1359: x_msg_data,
1360: '_PVT'
1361: );

Line 1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1359: x_msg_data,
1360: '_PVT'
1361: );
1362: WHEN OTHERS THEN
1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,
1367: 'OTHERS',

Line 1378: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1374: -- insert_row for :OKL_SUPP_INVOICE_DTLS_V --
1375: ---------------------------------------------
1376: PROCEDURE insert_row(
1377: p_api_version IN NUMBER,
1378: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1379: x_return_status OUT NOCOPY VARCHAR2,
1380: x_msg_count OUT NOCOPY NUMBER,
1381: x_msg_data OUT NOCOPY VARCHAR2,
1382: p_vfav_rec IN vfav_rec_type,

Line 1387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1383: x_vfav_rec OUT NOCOPY vfav_rec_type) IS
1384:
1385: l_api_version CONSTANT NUMBER := 1;
1386: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1388: l_vfav_rec vfav_rec_type := p_vfav_rec;
1389: l_def_vfav_rec vfav_rec_type;
1390: l_vfa_rec vfa_rec_type;
1391: lx_vfa_rec vfa_rec_type;

Line 1414: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1410: FUNCTION Set_Attributes (
1411: p_vfav_rec IN vfav_rec_type,
1412: x_vfav_rec OUT NOCOPY vfav_rec_type
1413: ) RETURN VARCHAR2 IS
1414: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1415: BEGIN
1416: x_vfav_rec := p_vfav_rec;
1417: x_vfav_rec.OBJECT_VERSION_NUMBER := 1;
1418: RETURN(l_return_status);

Line 1421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1417: x_vfav_rec.OBJECT_VERSION_NUMBER := 1;
1418: RETURN(l_return_status);
1419: END Set_Attributes;
1420: BEGIN
1421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1422: G_PKG_NAME,
1423: p_init_msg_list,
1424: l_api_version,
1425: p_api_version,

Line 1428: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1424: l_api_version,
1425: p_api_version,
1426: '_PVT',
1427: x_return_status);
1428: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_ERROR;
1432: END IF;

Line 1429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1425: p_api_version,
1426: '_PVT',
1427: x_return_status);
1428: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: l_vfav_rec := null_out_defaults(p_vfav_rec);

Line 1430: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1426: '_PVT',
1427: x_return_status);
1428: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: l_vfav_rec := null_out_defaults(p_vfav_rec);
1434: -- Set primary key value

Line 1431: RAISE OKL_API.G_EXCEPTION_ERROR;

1427: x_return_status);
1428: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1431: RAISE OKL_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: l_vfav_rec := null_out_defaults(p_vfav_rec);
1434: -- Set primary key value
1435: l_vfav_rec.ID := get_seq_id;

Line 1441: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1437: l_return_Status := Set_Attributes(
1438: l_vfav_rec, -- IN
1439: l_def_vfav_rec); -- OUT
1440: --- If any errors happen abort API
1441: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1443: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_ERROR;
1445: END IF;

Line 1442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1438: l_vfav_rec, -- IN
1439: l_def_vfav_rec); -- OUT
1440: --- If any errors happen abort API
1441: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1443: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_ERROR;
1445: END IF;
1446: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);

Line 1443: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1439: l_def_vfav_rec); -- OUT
1440: --- If any errors happen abort API
1441: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1443: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_ERROR;
1445: END IF;
1446: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
1447: --- Validate all non-missing attributes (Item Level Validation)

Line 1444: RAISE OKL_API.G_EXCEPTION_ERROR;

1440: --- If any errors happen abort API
1441: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1442: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1443: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_ERROR;
1445: END IF;
1446: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
1447: --- Validate all non-missing attributes (Item Level Validation)
1448: l_return_status := Validate_Attributes(l_def_vfav_rec);

Line 1450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1446: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
1447: --- Validate all non-missing attributes (Item Level Validation)
1448: l_return_status := Validate_Attributes(l_def_vfav_rec);
1449: --- If any errors happen abort API
1450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;

Line 1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1447: --- Validate all non-missing attributes (Item Level Validation)
1448: l_return_status := Validate_Attributes(l_def_vfav_rec);
1449: --- If any errors happen abort API
1450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);

Line 1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1448: l_return_status := Validate_Attributes(l_def_vfav_rec);
1449: --- If any errors happen abort API
1450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1453: RAISE OKL_API.G_EXCEPTION_ERROR;

1449: --- If any errors happen abort API
1450: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1452: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;

Line 1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: -----------------------------------------

Line 1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1454: END IF;
1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: -----------------------------------------
1462: -- Move VIEW record to "Child" records --

Line 1459: RAISE OKL_API.G_EXCEPTION_ERROR;

1455: l_return_status := Validate_Record(l_def_vfav_rec);
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: -----------------------------------------
1462: -- Move VIEW record to "Child" records --
1463: -----------------------------------------

Line 1476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1472: x_msg_data,
1473: l_vfa_rec,
1474: lx_vfa_rec
1475: );
1476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;

Line 1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1473: l_vfa_rec,
1474: lx_vfa_rec
1475: );
1476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: migrate(lx_vfa_rec, l_def_vfav_rec);

Line 1478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1474: lx_vfa_rec
1475: );
1476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: migrate(lx_vfa_rec, l_def_vfav_rec);
1482: -- Set OUT values

Line 1479: RAISE OKL_API.G_EXCEPTION_ERROR;

1475: );
1476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1479: RAISE OKL_API.G_EXCEPTION_ERROR;
1480: END IF;
1481: migrate(lx_vfa_rec, l_def_vfav_rec);
1482: -- Set OUT values
1483: x_vfav_rec := l_def_vfav_rec;

Line 1485: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1481: migrate(lx_vfa_rec, l_def_vfav_rec);
1482: -- Set OUT values
1483: x_vfav_rec := l_def_vfav_rec;
1484: x_return_status := l_return_status;
1485: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1486: EXCEPTION
1487: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1488: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1489: (

Line 1487: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1483: x_vfav_rec := l_def_vfav_rec;
1484: x_return_status := l_return_status;
1485: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1486: EXCEPTION
1487: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1488: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1489: (
1490: l_api_name,
1491: G_PKG_NAME,

Line 1488: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1484: x_return_status := l_return_status;
1485: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1486: EXCEPTION
1487: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1488: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1489: (
1490: l_api_name,
1491: G_PKG_NAME,
1492: 'OKL_API.G_RET_STS_ERROR',

Line 1492: 'OKL_API.G_RET_STS_ERROR',

1488: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1489: (
1490: l_api_name,
1491: G_PKG_NAME,
1492: 'OKL_API.G_RET_STS_ERROR',
1493: x_msg_count,
1494: x_msg_data,
1495: '_PVT'
1496: );

Line 1497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1493: x_msg_count,
1494: x_msg_data,
1495: '_PVT'
1496: );
1497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1498: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1499: (
1500: l_api_name,
1501: G_PKG_NAME,

Line 1498: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1494: x_msg_data,
1495: '_PVT'
1496: );
1497: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1498: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1499: (
1500: l_api_name,
1501: G_PKG_NAME,
1502: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1502: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1498: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1499: (
1500: l_api_name,
1501: G_PKG_NAME,
1502: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1503: x_msg_count,
1504: x_msg_data,
1505: '_PVT'
1506: );

Line 1508: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1504: x_msg_data,
1505: '_PVT'
1506: );
1507: WHEN OTHERS THEN
1508: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1509: (
1510: l_api_name,
1511: G_PKG_NAME,
1512: 'OTHERS',

Line 1523: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1519: -- PL/SQL TBL insert_row for:vfaV_TBL --
1520: ----------------------------------------
1521: PROCEDURE insert_row(
1522: p_api_version IN NUMBER,
1523: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1524: x_return_status OUT NOCOPY VARCHAR2,
1525: x_msg_count OUT NOCOPY NUMBER,
1526: x_msg_data OUT NOCOPY VARCHAR2,
1527: p_vfav_tbl IN vfav_tbl_type,

Line 1534: OKL_API.init_msg_list(p_init_msg_list);

1530: l_api_version CONSTANT NUMBER := 1;
1531: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1532: i NUMBER := 0;
1533: BEGIN
1534: OKL_API.init_msg_list(p_init_msg_list);
1535: -- Make sure PL/SQL table has records in it before passing
1536: IF (p_vfav_tbl.COUNT > 0) THEN
1537: i := p_vfav_tbl.FIRST;
1538: LOOP

Line 1551: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1547: EXIT WHEN (i = p_vfav_tbl.LAST);
1548: i := p_vfav_tbl.NEXT(i);
1549: END LOOP;
1550: END IF;
1551: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1552: EXCEPTION
1553: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1555: (

Line 1553: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1549: END LOOP;
1550: END IF;
1551: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1552: EXCEPTION
1553: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1555: (
1556: l_api_name,
1557: G_PKG_NAME,

Line 1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1550: END IF;
1551: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1552: EXCEPTION
1553: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1555: (
1556: l_api_name,
1557: G_PKG_NAME,
1558: 'OKL_API.G_RET_STS_ERROR',

Line 1558: 'OKL_API.G_RET_STS_ERROR',

1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1555: (
1556: l_api_name,
1557: G_PKG_NAME,
1558: 'OKL_API.G_RET_STS_ERROR',
1559: x_msg_count,
1560: x_msg_data,
1561: '_PVT'
1562: );

Line 1563: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1559: x_msg_count,
1560: x_msg_data,
1561: '_PVT'
1562: );
1563: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (
1566: l_api_name,
1567: G_PKG_NAME,

Line 1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1560: x_msg_data,
1561: '_PVT'
1562: );
1563: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (
1566: l_api_name,
1567: G_PKG_NAME,
1568: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1568: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (
1566: l_api_name,
1567: G_PKG_NAME,
1568: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1569: x_msg_count,
1570: x_msg_data,
1571: '_PVT'
1572: );

Line 1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1570: x_msg_data,
1571: '_PVT'
1572: );
1573: WHEN OTHERS THEN
1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1575: (
1576: l_api_name,
1577: G_PKG_NAME,
1578: 'OTHERS',

Line 1591: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1587: ----------------------------------------
1588: -- lock_row for:OKL_CONTRACT_ASSET_HV --
1589: ----------------------------------------
1590: PROCEDURE lock_row(
1591: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1592: x_return_status OUT NOCOPY VARCHAR2,
1593: x_msg_count OUT NOCOPY NUMBER,
1594: x_msg_data OUT NOCOPY VARCHAR2,
1595: p_vfa_rec IN vfa_rec_type) IS

Line 1611: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1607: FROM OKL_CONTRACT_ASSET_H
1608: WHERE ID = p_vfa_rec.id;
1609: l_api_version CONSTANT NUMBER := 1;
1610: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1611: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1612: l_object_version_number OKL_CONTRACT_ASSET_H.OBJECT_VERSION_NUMBER%TYPE;
1613: lc_object_version_number OKL_CONTRACT_ASSET_H.OBJECT_VERSION_NUMBER%TYPE;
1614: l_row_notfound BOOLEAN := FALSE;
1615: lc_row_notfound BOOLEAN := FALSE;

Line 1617: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1613: lc_object_version_number OKL_CONTRACT_ASSET_H.OBJECT_VERSION_NUMBER%TYPE;
1614: l_row_notfound BOOLEAN := FALSE;
1615: lc_row_notfound BOOLEAN := FALSE;
1616: BEGIN
1617: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1618: p_init_msg_list,
1619: '_PVT',
1620: x_return_status);
1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1617: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1618: p_init_msg_list,
1619: '_PVT',
1620: x_return_status);
1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;

Line 1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1618: p_init_msg_list,
1619: '_PVT',
1620: x_return_status);
1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626: BEGIN

Line 1623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1619: '_PVT',
1620: x_return_status);
1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626: BEGIN
1627: OPEN lock_csr(p_vfa_rec);

Line 1624: RAISE OKL_API.G_EXCEPTION_ERROR;

1620: x_return_status);
1621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626: BEGIN
1627: OPEN lock_csr(p_vfa_rec);
1628: FETCH lock_csr INTO l_object_version_number;

Line 1636: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1632: WHEN E_Resource_Busy THEN
1633: IF (lock_csr%ISOPEN) THEN
1634: CLOSE lock_csr;
1635: END IF;
1636: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1637: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1638: END;
1639:
1640: IF ( l_row_notfound ) THEN

Line 1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1643: lc_row_notfound := lchk_csr%NOTFOUND;
1644: CLOSE lchk_csr;
1645: END IF;
1646: IF (lc_row_notfound) THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number > p_vfa_rec.object_version_number THEN
1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1648: RAISE OKL_API.G_EXCEPTION_ERROR;

1644: CLOSE lchk_csr;
1645: END IF;
1646: IF (lc_row_notfound) THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number > p_vfa_rec.object_version_number THEN
1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN

Line 1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1646: IF (lc_row_notfound) THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number > p_vfa_rec.object_version_number THEN
1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN
1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1651: RAISE OKL_API.G_EXCEPTION_ERROR;

1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number > p_vfa_rec.object_version_number THEN
1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN
1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;
1655: ELSIF lc_object_version_number = -1 THEN

Line 1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1649: ELSIF lc_object_version_number > p_vfa_rec.object_version_number THEN
1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN
1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;
1655: ELSIF lc_object_version_number = -1 THEN
1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1657: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1654: RAISE OKL_API.G_EXCEPTION_ERROR;

1650: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN
1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;
1655: ELSIF lc_object_version_number = -1 THEN
1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1657: RAISE OKL_API.G_EXCEPTION_ERROR;
1658: END IF;

Line 1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1652: ELSIF lc_object_version_number <> p_vfa_rec.object_version_number THEN
1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;
1655: ELSIF lc_object_version_number = -1 THEN
1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1657: RAISE OKL_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: x_return_status := l_return_status;
1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1657: RAISE OKL_API.G_EXCEPTION_ERROR;

1653: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1654: RAISE OKL_API.G_EXCEPTION_ERROR;
1655: ELSIF lc_object_version_number = -1 THEN
1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1657: RAISE OKL_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: x_return_status := l_return_status;
1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1661: EXCEPTION

Line 1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1656: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1657: RAISE OKL_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: x_return_status := l_return_status;
1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1661: EXCEPTION
1662: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1664: (

Line 1662: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1658: END IF;
1659: x_return_status := l_return_status;
1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1661: EXCEPTION
1662: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,

Line 1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1659: x_return_status := l_return_status;
1660: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1661: EXCEPTION
1662: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,
1667: 'OKL_API.G_RET_STS_ERROR',

Line 1667: 'OKL_API.G_RET_STS_ERROR',

1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,
1667: 'OKL_API.G_RET_STS_ERROR',
1668: x_msg_count,
1669: x_msg_data,
1670: '_PVT'
1671: );

Line 1672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1668: x_msg_count,
1669: x_msg_data,
1670: '_PVT'
1671: );
1672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1674: (
1675: l_api_name,
1676: G_PKG_NAME,

Line 1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1669: x_msg_data,
1670: '_PVT'
1671: );
1672: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1674: (
1675: l_api_name,
1676: G_PKG_NAME,
1677: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1677: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1673: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1674: (
1675: l_api_name,
1676: G_PKG_NAME,
1677: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1678: x_msg_count,
1679: x_msg_data,
1680: '_PVT'
1681: );

Line 1683: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1679: x_msg_data,
1680: '_PVT'
1681: );
1682: WHEN OTHERS THEN
1683: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1684: (
1685: l_api_name,
1686: G_PKG_NAME,
1687: 'OTHERS',

Line 1698: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1694: -- lock_row for: OKL_CONTRACT_ASSET_HV --
1695: -----------------------------------------
1696: PROCEDURE lock_row(
1697: p_api_version IN NUMBER,
1698: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1699: x_return_status OUT NOCOPY VARCHAR2,
1700: x_msg_count OUT NOCOPY NUMBER,
1701: x_msg_data OUT NOCOPY VARCHAR2,
1702: p_vfav_rec IN vfav_rec_type) IS

Line 1706: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1702: p_vfav_rec IN vfav_rec_type) IS
1703:
1704: l_api_version CONSTANT NUMBER := 1;
1705: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1706: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1707: l_vfav_rec vfav_rec_type;
1708: l_vfa_rec vfa_rec_type;
1709: BEGIN
1710: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 1710: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1706: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1707: l_vfav_rec vfav_rec_type;
1708: l_vfa_rec vfa_rec_type;
1709: BEGIN
1710: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1711: G_PKG_NAME,
1712: p_init_msg_list,
1713: l_api_version,
1714: p_api_version,

Line 1717: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1713: l_api_version,
1714: p_api_version,
1715: '_PVT',
1716: x_return_status);
1717: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1719: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1720: RAISE OKL_API.G_EXCEPTION_ERROR;
1721: END IF;

Line 1718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1714: p_api_version,
1715: '_PVT',
1716: x_return_status);
1717: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1719: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1720: RAISE OKL_API.G_EXCEPTION_ERROR;
1721: END IF;
1722: -----------------------------------------

Line 1719: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1715: '_PVT',
1716: x_return_status);
1717: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1719: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1720: RAISE OKL_API.G_EXCEPTION_ERROR;
1721: END IF;
1722: -----------------------------------------
1723: -- Move VIEW record to "Child" records --

Line 1720: RAISE OKL_API.G_EXCEPTION_ERROR;

1716: x_return_status);
1717: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1718: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1719: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1720: RAISE OKL_API.G_EXCEPTION_ERROR;
1721: END IF;
1722: -----------------------------------------
1723: -- Move VIEW record to "Child" records --
1724: -----------------------------------------

Line 1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1732: x_msg_count,
1733: x_msg_data,
1734: l_vfa_rec
1735: );
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;

Line 1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1733: x_msg_data,
1734: l_vfa_rec
1735: );
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: x_return_status := l_return_status;

Line 1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1734: l_vfa_rec
1735: );
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: x_return_status := l_return_status;
1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1739: RAISE OKL_API.G_EXCEPTION_ERROR;

1735: );
1736: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: x_return_status := l_return_status;
1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1743: EXCEPTION

Line 1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1738: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1739: RAISE OKL_API.G_EXCEPTION_ERROR;
1740: END IF;
1741: x_return_status := l_return_status;
1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1743: EXCEPTION
1744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1745: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1746: (

Line 1744: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1740: END IF;
1741: x_return_status := l_return_status;
1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1743: EXCEPTION
1744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1745: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1746: (
1747: l_api_name,
1748: G_PKG_NAME,

Line 1745: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1741: x_return_status := l_return_status;
1742: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1743: EXCEPTION
1744: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1745: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1746: (
1747: l_api_name,
1748: G_PKG_NAME,
1749: 'OKL_API.G_RET_STS_ERROR',

Line 1749: 'OKL_API.G_RET_STS_ERROR',

1745: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1746: (
1747: l_api_name,
1748: G_PKG_NAME,
1749: 'OKL_API.G_RET_STS_ERROR',
1750: x_msg_count,
1751: x_msg_data,
1752: '_PVT'
1753: );

Line 1754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1750: x_msg_count,
1751: x_msg_data,
1752: '_PVT'
1753: );
1754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1756: (
1757: l_api_name,
1758: G_PKG_NAME,

Line 1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1751: x_msg_data,
1752: '_PVT'
1753: );
1754: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1756: (
1757: l_api_name,
1758: G_PKG_NAME,
1759: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1759: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1756: (
1757: l_api_name,
1758: G_PKG_NAME,
1759: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1760: x_msg_count,
1761: x_msg_data,
1762: '_PVT'
1763: );

Line 1765: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1761: x_msg_data,
1762: '_PVT'
1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1766: (
1767: l_api_name,
1768: G_PKG_NAME,
1769: 'OTHERS',

Line 1780: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1776: -- PL/SQL TBL lock_row for:VFAV_TBL --
1777: --------------------------------------
1778: PROCEDURE lock_row(
1779: p_api_version IN NUMBER,
1780: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1781: x_return_status OUT NOCOPY VARCHAR2,
1782: x_msg_count OUT NOCOPY NUMBER,
1783: x_msg_data OUT NOCOPY VARCHAR2,
1784: p_vfav_tbl IN vfav_tbl_type) IS

Line 1790: OKL_API.init_msg_list(p_init_msg_list);

1786: l_api_version CONSTANT NUMBER := 1;
1787: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1788: i NUMBER := 0;
1789: BEGIN
1790: OKL_API.init_msg_list(p_init_msg_list);
1791: -- Make sure PL/SQL table has recrods in it before passing
1792: IF (p_vfav_tbl.COUNT > 0) THEN
1793: i := p_vfav_tbl.FIRST;
1794: LOOP

Line 1806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1802: EXIT WHEN (i = p_vfav_tbl.LAST);
1803: i := p_vfav_tbl.NEXT(i);
1804: END LOOP;
1805: END IF;
1806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1807: EXCEPTION
1808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1810: (

Line 1808: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1804: END LOOP;
1805: END IF;
1806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1807: EXCEPTION
1808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1810: (
1811: l_api_name,
1812: G_PKG_NAME,

Line 1809: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1805: END IF;
1806: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1807: EXCEPTION
1808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1810: (
1811: l_api_name,
1812: G_PKG_NAME,
1813: 'OKL_API.G_RET_STS_ERROR',

Line 1813: 'OKL_API.G_RET_STS_ERROR',

1809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1810: (
1811: l_api_name,
1812: G_PKG_NAME,
1813: 'OKL_API.G_RET_STS_ERROR',
1814: x_msg_count,
1815: x_msg_data,
1816: '_PVT'
1817: );

Line 1818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1814: x_msg_count,
1815: x_msg_data,
1816: '_PVT'
1817: );
1818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1819: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,

Line 1819: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1815: x_msg_data,
1816: '_PVT'
1817: );
1818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1819: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,
1823: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1823: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1819: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1820: (
1821: l_api_name,
1822: G_PKG_NAME,
1823: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1824: x_msg_count,
1825: x_msg_data,
1826: '_PVT'
1827: );

Line 1829: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1825: x_msg_data,
1826: '_PVT'
1827: );
1828: WHEN OTHERS THEN
1829: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1830: (
1831: l_api_name,
1832: G_PKG_NAME,
1833: 'OTHERS',

Line 1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1842: ------------------------------------------
1843: -- update_row for:OKL_CONTRACT_ASSET_HV --
1844: ------------------------------------------
1845: PROCEDURE update_row(
1846: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1847: x_return_status OUT NOCOPY VARCHAR2,
1848: x_msg_count OUT NOCOPY NUMBER,
1849: x_msg_data OUT NOCOPY VARCHAR2,
1850: p_vfa_rec IN vfa_rec_type,

Line 1855: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1851: x_vfa_rec OUT NOCOPY vfa_rec_type) IS
1852:
1853: l_api_version CONSTANT NUMBER := 1;
1854: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1855: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1856: l_vfa_rec vfa_rec_type := p_vfa_rec;
1857: l_def_vfa_rec vfa_rec_type;
1858: l_row_notfound BOOLEAN := TRUE;
1859: ----------------------------------

Line 1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1864: x_vfa_rec OUT NOCOPY vfa_rec_type
1865: ) RETURN VARCHAR2 IS
1866: l_vfa_rec vfa_rec_type;
1867: l_row_notfound BOOLEAN := TRUE;
1868: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1869: BEGIN
1870: x_vfa_rec := p_vfa_rec;
1871: -- Get current database values
1872: l_vfa_rec := get_rec(p_vfa_rec, l_return_status);

Line 1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1869: BEGIN
1870: x_vfa_rec := p_vfa_rec;
1871: -- Get current database values
1872: l_vfa_rec := get_rec(p_vfa_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_vfa_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_vfa_rec.id := l_vfa_rec.id;
1877: END IF;

Line 1874: IF (x_vfa_rec.id = OKL_API.G_MISS_NUM)

1870: x_vfa_rec := p_vfa_rec;
1871: -- Get current database values
1872: l_vfa_rec := get_rec(p_vfa_rec, l_return_status);
1873: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1874: IF (x_vfa_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_vfa_rec.id := l_vfa_rec.id;
1877: END IF;
1878: IF (x_vfa_rec.major_version = OKL_API.G_MISS_NUM)

Line 1878: IF (x_vfa_rec.major_version = OKL_API.G_MISS_NUM)

1874: IF (x_vfa_rec.id = OKL_API.G_MISS_NUM)
1875: THEN
1876: x_vfa_rec.id := l_vfa_rec.id;
1877: END IF;
1878: IF (x_vfa_rec.major_version = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_vfa_rec.major_version := l_vfa_rec.major_version;
1881: END IF;
1882: IF (x_vfa_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1882: IF (x_vfa_rec.object_version_number = OKL_API.G_MISS_NUM)

1878: IF (x_vfa_rec.major_version = OKL_API.G_MISS_NUM)
1879: THEN
1880: x_vfa_rec.major_version := l_vfa_rec.major_version;
1881: END IF;
1882: IF (x_vfa_rec.object_version_number = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_vfa_rec.object_version_number := l_vfa_rec.object_version_number;
1885: END IF;
1886: IF (x_vfa_rec.dnz_chr_id = OKL_API.G_MISS_NUM)

Line 1886: IF (x_vfa_rec.dnz_chr_id = OKL_API.G_MISS_NUM)

1882: IF (x_vfa_rec.object_version_number = OKL_API.G_MISS_NUM)
1883: THEN
1884: x_vfa_rec.object_version_number := l_vfa_rec.object_version_number;
1885: END IF;
1886: IF (x_vfa_rec.dnz_chr_id = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_vfa_rec.dnz_chr_id := l_vfa_rec.dnz_chr_id;
1889: END IF;
1890: IF (x_vfa_rec.fa_cle_id = OKL_API.G_MISS_NUM)

Line 1890: IF (x_vfa_rec.fa_cle_id = OKL_API.G_MISS_NUM)

1886: IF (x_vfa_rec.dnz_chr_id = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_vfa_rec.dnz_chr_id := l_vfa_rec.dnz_chr_id;
1889: END IF;
1890: IF (x_vfa_rec.fa_cle_id = OKL_API.G_MISS_NUM)
1891: THEN
1892: x_vfa_rec.fa_cle_id := l_vfa_rec.fa_cle_id;
1893: END IF;
1894: IF (x_vfa_rec.name = OKL_API.G_MISS_CHAR)

Line 1894: IF (x_vfa_rec.name = OKL_API.G_MISS_CHAR)

1890: IF (x_vfa_rec.fa_cle_id = OKL_API.G_MISS_NUM)
1891: THEN
1892: x_vfa_rec.fa_cle_id := l_vfa_rec.fa_cle_id;
1893: END IF;
1894: IF (x_vfa_rec.name = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_vfa_rec.name := l_vfa_rec.name;
1897: END IF;
1898: IF (x_vfa_rec.description = OKL_API.G_MISS_CHAR)

Line 1898: IF (x_vfa_rec.description = OKL_API.G_MISS_CHAR)

1894: IF (x_vfa_rec.name = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_vfa_rec.name := l_vfa_rec.name;
1897: END IF;
1898: IF (x_vfa_rec.description = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_vfa_rec.description := l_vfa_rec.description;
1901: END IF;
1902: IF (x_vfa_rec.asset_id = OKL_API.G_MISS_NUM)

Line 1902: IF (x_vfa_rec.asset_id = OKL_API.G_MISS_NUM)

1898: IF (x_vfa_rec.description = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_vfa_rec.description := l_vfa_rec.description;
1901: END IF;
1902: IF (x_vfa_rec.asset_id = OKL_API.G_MISS_NUM)
1903: THEN
1904: x_vfa_rec.asset_id := l_vfa_rec.asset_id;
1905: END IF;
1906: IF (x_vfa_rec.asset_number = OKL_API.G_MISS_CHAR)

Line 1906: IF (x_vfa_rec.asset_number = OKL_API.G_MISS_CHAR)

1902: IF (x_vfa_rec.asset_id = OKL_API.G_MISS_NUM)
1903: THEN
1904: x_vfa_rec.asset_id := l_vfa_rec.asset_id;
1905: END IF;
1906: IF (x_vfa_rec.asset_number = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_vfa_rec.asset_number := l_vfa_rec.asset_number;
1909: END IF;
1910: IF (x_vfa_rec.corporate_book = OKL_API.G_MISS_CHAR)

Line 1910: IF (x_vfa_rec.corporate_book = OKL_API.G_MISS_CHAR)

1906: IF (x_vfa_rec.asset_number = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_vfa_rec.asset_number := l_vfa_rec.asset_number;
1909: END IF;
1910: IF (x_vfa_rec.corporate_book = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_vfa_rec.corporate_book := l_vfa_rec.corporate_book;
1913: END IF;
1914: IF (x_vfa_rec.life_in_months = OKL_API.G_MISS_NUM)

Line 1914: IF (x_vfa_rec.life_in_months = OKL_API.G_MISS_NUM)

1910: IF (x_vfa_rec.corporate_book = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_vfa_rec.corporate_book := l_vfa_rec.corporate_book;
1913: END IF;
1914: IF (x_vfa_rec.life_in_months = OKL_API.G_MISS_NUM)
1915: THEN
1916: x_vfa_rec.life_in_months := l_vfa_rec.life_in_months;
1917: END IF;
1918: IF (x_vfa_rec.original_cost = OKL_API.G_MISS_NUM)

Line 1918: IF (x_vfa_rec.original_cost = OKL_API.G_MISS_NUM)

1914: IF (x_vfa_rec.life_in_months = OKL_API.G_MISS_NUM)
1915: THEN
1916: x_vfa_rec.life_in_months := l_vfa_rec.life_in_months;
1917: END IF;
1918: IF (x_vfa_rec.original_cost = OKL_API.G_MISS_NUM)
1919: THEN
1920: x_vfa_rec.original_cost := l_vfa_rec.original_cost;
1921: END IF;
1922: IF (x_vfa_rec.cost = OKL_API.G_MISS_NUM)

Line 1922: IF (x_vfa_rec.cost = OKL_API.G_MISS_NUM)

1918: IF (x_vfa_rec.original_cost = OKL_API.G_MISS_NUM)
1919: THEN
1920: x_vfa_rec.original_cost := l_vfa_rec.original_cost;
1921: END IF;
1922: IF (x_vfa_rec.cost = OKL_API.G_MISS_NUM)
1923: THEN
1924: x_vfa_rec.cost := l_vfa_rec.cost;
1925: END IF;
1926: IF (x_vfa_rec.adjusted_cost = OKL_API.G_MISS_NUM)

Line 1926: IF (x_vfa_rec.adjusted_cost = OKL_API.G_MISS_NUM)

1922: IF (x_vfa_rec.cost = OKL_API.G_MISS_NUM)
1923: THEN
1924: x_vfa_rec.cost := l_vfa_rec.cost;
1925: END IF;
1926: IF (x_vfa_rec.adjusted_cost = OKL_API.G_MISS_NUM)
1927: THEN
1928: x_vfa_rec.adjusted_cost := l_vfa_rec.adjusted_cost;
1929: END IF;
1930: IF (x_vfa_rec.current_units = OKL_API.G_MISS_NUM)

Line 1930: IF (x_vfa_rec.current_units = OKL_API.G_MISS_NUM)

1926: IF (x_vfa_rec.adjusted_cost = OKL_API.G_MISS_NUM)
1927: THEN
1928: x_vfa_rec.adjusted_cost := l_vfa_rec.adjusted_cost;
1929: END IF;
1930: IF (x_vfa_rec.current_units = OKL_API.G_MISS_NUM)
1931: THEN
1932: x_vfa_rec.current_units := l_vfa_rec.current_units;
1933: END IF;
1934: IF (x_vfa_rec.new_used = OKL_API.G_MISS_CHAR)

Line 1934: IF (x_vfa_rec.new_used = OKL_API.G_MISS_CHAR)

1930: IF (x_vfa_rec.current_units = OKL_API.G_MISS_NUM)
1931: THEN
1932: x_vfa_rec.current_units := l_vfa_rec.current_units;
1933: END IF;
1934: IF (x_vfa_rec.new_used = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_vfa_rec.new_used := l_vfa_rec.new_used;
1937: END IF;
1938: IF (x_vfa_rec.in_service_date = OKL_API.G_MISS_DATE)

Line 1938: IF (x_vfa_rec.in_service_date = OKL_API.G_MISS_DATE)

1934: IF (x_vfa_rec.new_used = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_vfa_rec.new_used := l_vfa_rec.new_used;
1937: END IF;
1938: IF (x_vfa_rec.in_service_date = OKL_API.G_MISS_DATE)
1939: THEN
1940: x_vfa_rec.in_service_date := l_vfa_rec.in_service_date;
1941: END IF;
1942: IF (x_vfa_rec.model_number = OKL_API.G_MISS_CHAR)

Line 1942: IF (x_vfa_rec.model_number = OKL_API.G_MISS_CHAR)

1938: IF (x_vfa_rec.in_service_date = OKL_API.G_MISS_DATE)
1939: THEN
1940: x_vfa_rec.in_service_date := l_vfa_rec.in_service_date;
1941: END IF;
1942: IF (x_vfa_rec.model_number = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_vfa_rec.model_number := l_vfa_rec.model_number;
1945: END IF;
1946: IF (x_vfa_rec.asset_type = OKL_API.G_MISS_CHAR)

Line 1946: IF (x_vfa_rec.asset_type = OKL_API.G_MISS_CHAR)

1942: IF (x_vfa_rec.model_number = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_vfa_rec.model_number := l_vfa_rec.model_number;
1945: END IF;
1946: IF (x_vfa_rec.asset_type = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_vfa_rec.asset_type := l_vfa_rec.asset_type;
1949: END IF;
1950: IF (x_vfa_rec.salvage_value = OKL_API.G_MISS_NUM)

Line 1950: IF (x_vfa_rec.salvage_value = OKL_API.G_MISS_NUM)

1946: IF (x_vfa_rec.asset_type = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_vfa_rec.asset_type := l_vfa_rec.asset_type;
1949: END IF;
1950: IF (x_vfa_rec.salvage_value = OKL_API.G_MISS_NUM)
1951: THEN
1952: x_vfa_rec.salvage_value := l_vfa_rec.salvage_value;
1953: END IF;
1954: IF (x_vfa_rec.percent_salvage_value = OKL_API.G_MISS_NUM)

Line 1954: IF (x_vfa_rec.percent_salvage_value = OKL_API.G_MISS_NUM)

1950: IF (x_vfa_rec.salvage_value = OKL_API.G_MISS_NUM)
1951: THEN
1952: x_vfa_rec.salvage_value := l_vfa_rec.salvage_value;
1953: END IF;
1954: IF (x_vfa_rec.percent_salvage_value = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_vfa_rec.percent_salvage_value := l_vfa_rec.percent_salvage_value;
1957: END IF;
1958: IF (x_vfa_rec.depreciation_category = OKL_API.G_MISS_NUM)

Line 1958: IF (x_vfa_rec.depreciation_category = OKL_API.G_MISS_NUM)

1954: IF (x_vfa_rec.percent_salvage_value = OKL_API.G_MISS_NUM)
1955: THEN
1956: x_vfa_rec.percent_salvage_value := l_vfa_rec.percent_salvage_value;
1957: END IF;
1958: IF (x_vfa_rec.depreciation_category = OKL_API.G_MISS_NUM)
1959: THEN
1960: x_vfa_rec.depreciation_category := l_vfa_rec.depreciation_category;
1961: END IF;
1962: IF (x_vfa_rec.deprn_start_date = OKL_API.G_MISS_DATE)

Line 1962: IF (x_vfa_rec.deprn_start_date = OKL_API.G_MISS_DATE)

1958: IF (x_vfa_rec.depreciation_category = OKL_API.G_MISS_NUM)
1959: THEN
1960: x_vfa_rec.depreciation_category := l_vfa_rec.depreciation_category;
1961: END IF;
1962: IF (x_vfa_rec.deprn_start_date = OKL_API.G_MISS_DATE)
1963: THEN
1964: x_vfa_rec.deprn_start_date := l_vfa_rec.deprn_start_date;
1965: END IF;
1966: IF (x_vfa_rec.deprn_method_code = OKL_API.G_MISS_CHAR)

Line 1966: IF (x_vfa_rec.deprn_method_code = OKL_API.G_MISS_CHAR)

1962: IF (x_vfa_rec.deprn_start_date = OKL_API.G_MISS_DATE)
1963: THEN
1964: x_vfa_rec.deprn_start_date := l_vfa_rec.deprn_start_date;
1965: END IF;
1966: IF (x_vfa_rec.deprn_method_code = OKL_API.G_MISS_CHAR)
1967: THEN
1968: x_vfa_rec.deprn_method_code := l_vfa_rec.deprn_method_code;
1969: END IF;
1970: IF (x_vfa_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)

Line 1970: IF (x_vfa_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)

1966: IF (x_vfa_rec.deprn_method_code = OKL_API.G_MISS_CHAR)
1967: THEN
1968: x_vfa_rec.deprn_method_code := l_vfa_rec.deprn_method_code;
1969: END IF;
1970: IF (x_vfa_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_vfa_rec.rate_adjustment_factor := l_vfa_rec.rate_adjustment_factor;
1973: END IF;
1974: IF (x_vfa_rec.basic_rate = OKL_API.G_MISS_NUM)

Line 1974: IF (x_vfa_rec.basic_rate = OKL_API.G_MISS_NUM)

1970: IF (x_vfa_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_vfa_rec.rate_adjustment_factor := l_vfa_rec.rate_adjustment_factor;
1973: END IF;
1974: IF (x_vfa_rec.basic_rate = OKL_API.G_MISS_NUM)
1975: THEN
1976: x_vfa_rec.basic_rate := l_vfa_rec.basic_rate;
1977: END IF;
1978: IF (x_vfa_rec.adjusted_rate = OKL_API.G_MISS_NUM)

Line 1978: IF (x_vfa_rec.adjusted_rate = OKL_API.G_MISS_NUM)

1974: IF (x_vfa_rec.basic_rate = OKL_API.G_MISS_NUM)
1975: THEN
1976: x_vfa_rec.basic_rate := l_vfa_rec.basic_rate;
1977: END IF;
1978: IF (x_vfa_rec.adjusted_rate = OKL_API.G_MISS_NUM)
1979: THEN
1980: x_vfa_rec.adjusted_rate := l_vfa_rec.adjusted_rate;
1981: END IF;
1982: IF (x_vfa_rec.start_date_active = OKL_API.G_MISS_DATE)

Line 1982: IF (x_vfa_rec.start_date_active = OKL_API.G_MISS_DATE)

1978: IF (x_vfa_rec.adjusted_rate = OKL_API.G_MISS_NUM)
1979: THEN
1980: x_vfa_rec.adjusted_rate := l_vfa_rec.adjusted_rate;
1981: END IF;
1982: IF (x_vfa_rec.start_date_active = OKL_API.G_MISS_DATE)
1983: THEN
1984: x_vfa_rec.start_date_active := l_vfa_rec.start_date_active;
1985: END IF;
1986: IF (x_vfa_rec.end_date_active = OKL_API.G_MISS_DATE)

Line 1986: IF (x_vfa_rec.end_date_active = OKL_API.G_MISS_DATE)

1982: IF (x_vfa_rec.start_date_active = OKL_API.G_MISS_DATE)
1983: THEN
1984: x_vfa_rec.start_date_active := l_vfa_rec.start_date_active;
1985: END IF;
1986: IF (x_vfa_rec.end_date_active = OKL_API.G_MISS_DATE)
1987: THEN
1988: x_vfa_rec.end_date_active := l_vfa_rec.end_date_active;
1989: END IF;
1990: IF (x_vfa_rec.status = OKL_API.G_MISS_CHAR)

Line 1990: IF (x_vfa_rec.status = OKL_API.G_MISS_CHAR)

1986: IF (x_vfa_rec.end_date_active = OKL_API.G_MISS_DATE)
1987: THEN
1988: x_vfa_rec.end_date_active := l_vfa_rec.end_date_active;
1989: END IF;
1990: IF (x_vfa_rec.status = OKL_API.G_MISS_CHAR)
1991: THEN
1992: x_vfa_rec.status := l_vfa_rec.status;
1993: END IF;
1994: IF (x_vfa_rec.primary_uom_code = OKL_API.G_MISS_CHAR)

Line 1994: IF (x_vfa_rec.primary_uom_code = OKL_API.G_MISS_CHAR)

1990: IF (x_vfa_rec.status = OKL_API.G_MISS_CHAR)
1991: THEN
1992: x_vfa_rec.status := l_vfa_rec.status;
1993: END IF;
1994: IF (x_vfa_rec.primary_uom_code = OKL_API.G_MISS_CHAR)
1995: THEN
1996: x_vfa_rec.primary_uom_code := l_vfa_rec.primary_uom_code;
1997: END IF;
1998: IF (x_vfa_rec.recoverable_cost = OKL_API.G_MISS_NUM)

Line 1998: IF (x_vfa_rec.recoverable_cost = OKL_API.G_MISS_NUM)

1994: IF (x_vfa_rec.primary_uom_code = OKL_API.G_MISS_CHAR)
1995: THEN
1996: x_vfa_rec.primary_uom_code := l_vfa_rec.primary_uom_code;
1997: END IF;
1998: IF (x_vfa_rec.recoverable_cost = OKL_API.G_MISS_NUM)
1999: THEN
2000: x_vfa_rec.recoverable_cost := l_vfa_rec.recoverable_cost;
2001: END IF;
2002: --Bug# 2981308

Line 2003: IF (x_vfa_rec.asset_key_id = OKL_API.G_MISS_NUM)

1999: THEN
2000: x_vfa_rec.recoverable_cost := l_vfa_rec.recoverable_cost;
2001: END IF;
2002: --Bug# 2981308
2003: IF (x_vfa_rec.asset_key_id = OKL_API.G_MISS_NUM)
2004: THEN
2005: x_vfa_rec.asset_key_id := l_vfa_rec.asset_key_id;
2006: END IF;
2007: IF (x_vfa_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2007: IF (x_vfa_rec.attribute_category = OKL_API.G_MISS_CHAR)

2003: IF (x_vfa_rec.asset_key_id = OKL_API.G_MISS_NUM)
2004: THEN
2005: x_vfa_rec.asset_key_id := l_vfa_rec.asset_key_id;
2006: END IF;
2007: IF (x_vfa_rec.attribute_category = OKL_API.G_MISS_CHAR)
2008: THEN
2009: x_vfa_rec.attribute_category := l_vfa_rec.attribute_category;
2010: END IF;
2011: IF (x_vfa_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2011: IF (x_vfa_rec.attribute1 = OKL_API.G_MISS_CHAR)

2007: IF (x_vfa_rec.attribute_category = OKL_API.G_MISS_CHAR)
2008: THEN
2009: x_vfa_rec.attribute_category := l_vfa_rec.attribute_category;
2010: END IF;
2011: IF (x_vfa_rec.attribute1 = OKL_API.G_MISS_CHAR)
2012: THEN
2013: x_vfa_rec.attribute1 := l_vfa_rec.attribute1;
2014: END IF;
2015: IF (x_vfa_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2015: IF (x_vfa_rec.attribute2 = OKL_API.G_MISS_CHAR)

2011: IF (x_vfa_rec.attribute1 = OKL_API.G_MISS_CHAR)
2012: THEN
2013: x_vfa_rec.attribute1 := l_vfa_rec.attribute1;
2014: END IF;
2015: IF (x_vfa_rec.attribute2 = OKL_API.G_MISS_CHAR)
2016: THEN
2017: x_vfa_rec.attribute2 := l_vfa_rec.attribute2;
2018: END IF;
2019: IF (x_vfa_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2019: IF (x_vfa_rec.attribute3 = OKL_API.G_MISS_CHAR)

2015: IF (x_vfa_rec.attribute2 = OKL_API.G_MISS_CHAR)
2016: THEN
2017: x_vfa_rec.attribute2 := l_vfa_rec.attribute2;
2018: END IF;
2019: IF (x_vfa_rec.attribute3 = OKL_API.G_MISS_CHAR)
2020: THEN
2021: x_vfa_rec.attribute3 := l_vfa_rec.attribute3;
2022: END IF;
2023: IF (x_vfa_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2023: IF (x_vfa_rec.attribute4 = OKL_API.G_MISS_CHAR)

2019: IF (x_vfa_rec.attribute3 = OKL_API.G_MISS_CHAR)
2020: THEN
2021: x_vfa_rec.attribute3 := l_vfa_rec.attribute3;
2022: END IF;
2023: IF (x_vfa_rec.attribute4 = OKL_API.G_MISS_CHAR)
2024: THEN
2025: x_vfa_rec.attribute4 := l_vfa_rec.attribute4;
2026: END IF;
2027: IF (x_vfa_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2027: IF (x_vfa_rec.attribute5 = OKL_API.G_MISS_CHAR)

2023: IF (x_vfa_rec.attribute4 = OKL_API.G_MISS_CHAR)
2024: THEN
2025: x_vfa_rec.attribute4 := l_vfa_rec.attribute4;
2026: END IF;
2027: IF (x_vfa_rec.attribute5 = OKL_API.G_MISS_CHAR)
2028: THEN
2029: x_vfa_rec.attribute5 := l_vfa_rec.attribute5;
2030: END IF;
2031: IF (x_vfa_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2031: IF (x_vfa_rec.attribute6 = OKL_API.G_MISS_CHAR)

2027: IF (x_vfa_rec.attribute5 = OKL_API.G_MISS_CHAR)
2028: THEN
2029: x_vfa_rec.attribute5 := l_vfa_rec.attribute5;
2030: END IF;
2031: IF (x_vfa_rec.attribute6 = OKL_API.G_MISS_CHAR)
2032: THEN
2033: x_vfa_rec.attribute6 := l_vfa_rec.attribute6;
2034: END IF;
2035: IF (x_vfa_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2035: IF (x_vfa_rec.attribute7 = OKL_API.G_MISS_CHAR)

2031: IF (x_vfa_rec.attribute6 = OKL_API.G_MISS_CHAR)
2032: THEN
2033: x_vfa_rec.attribute6 := l_vfa_rec.attribute6;
2034: END IF;
2035: IF (x_vfa_rec.attribute7 = OKL_API.G_MISS_CHAR)
2036: THEN
2037: x_vfa_rec.attribute7 := l_vfa_rec.attribute7;
2038: END IF;
2039: IF (x_vfa_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2039: IF (x_vfa_rec.attribute8 = OKL_API.G_MISS_CHAR)

2035: IF (x_vfa_rec.attribute7 = OKL_API.G_MISS_CHAR)
2036: THEN
2037: x_vfa_rec.attribute7 := l_vfa_rec.attribute7;
2038: END IF;
2039: IF (x_vfa_rec.attribute8 = OKL_API.G_MISS_CHAR)
2040: THEN
2041: x_vfa_rec.attribute8 := l_vfa_rec.attribute8;
2042: END IF;
2043: IF (x_vfa_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2043: IF (x_vfa_rec.attribute9 = OKL_API.G_MISS_CHAR)

2039: IF (x_vfa_rec.attribute8 = OKL_API.G_MISS_CHAR)
2040: THEN
2041: x_vfa_rec.attribute8 := l_vfa_rec.attribute8;
2042: END IF;
2043: IF (x_vfa_rec.attribute9 = OKL_API.G_MISS_CHAR)
2044: THEN
2045: x_vfa_rec.attribute9 := l_vfa_rec.attribute9;
2046: END IF;
2047: IF (x_vfa_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2047: IF (x_vfa_rec.attribute10 = OKL_API.G_MISS_CHAR)

2043: IF (x_vfa_rec.attribute9 = OKL_API.G_MISS_CHAR)
2044: THEN
2045: x_vfa_rec.attribute9 := l_vfa_rec.attribute9;
2046: END IF;
2047: IF (x_vfa_rec.attribute10 = OKL_API.G_MISS_CHAR)
2048: THEN
2049: x_vfa_rec.attribute10 := l_vfa_rec.attribute10;
2050: END IF;
2051: IF (x_vfa_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2051: IF (x_vfa_rec.attribute11 = OKL_API.G_MISS_CHAR)

2047: IF (x_vfa_rec.attribute10 = OKL_API.G_MISS_CHAR)
2048: THEN
2049: x_vfa_rec.attribute10 := l_vfa_rec.attribute10;
2050: END IF;
2051: IF (x_vfa_rec.attribute11 = OKL_API.G_MISS_CHAR)
2052: THEN
2053: x_vfa_rec.attribute11 := l_vfa_rec.attribute11;
2054: END IF;
2055: IF (x_vfa_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2055: IF (x_vfa_rec.attribute12 = OKL_API.G_MISS_CHAR)

2051: IF (x_vfa_rec.attribute11 = OKL_API.G_MISS_CHAR)
2052: THEN
2053: x_vfa_rec.attribute11 := l_vfa_rec.attribute11;
2054: END IF;
2055: IF (x_vfa_rec.attribute12 = OKL_API.G_MISS_CHAR)
2056: THEN
2057: x_vfa_rec.attribute12 := l_vfa_rec.attribute12;
2058: END IF;
2059: IF (x_vfa_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2059: IF (x_vfa_rec.attribute13 = OKL_API.G_MISS_CHAR)

2055: IF (x_vfa_rec.attribute12 = OKL_API.G_MISS_CHAR)
2056: THEN
2057: x_vfa_rec.attribute12 := l_vfa_rec.attribute12;
2058: END IF;
2059: IF (x_vfa_rec.attribute13 = OKL_API.G_MISS_CHAR)
2060: THEN
2061: x_vfa_rec.attribute13 := l_vfa_rec.attribute13;
2062: END IF;
2063: IF (x_vfa_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2063: IF (x_vfa_rec.attribute14 = OKL_API.G_MISS_CHAR)

2059: IF (x_vfa_rec.attribute13 = OKL_API.G_MISS_CHAR)
2060: THEN
2061: x_vfa_rec.attribute13 := l_vfa_rec.attribute13;
2062: END IF;
2063: IF (x_vfa_rec.attribute14 = OKL_API.G_MISS_CHAR)
2064: THEN
2065: x_vfa_rec.attribute14 := l_vfa_rec.attribute14;
2066: END IF;
2067: IF (x_vfa_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2067: IF (x_vfa_rec.attribute15 = OKL_API.G_MISS_CHAR)

2063: IF (x_vfa_rec.attribute14 = OKL_API.G_MISS_CHAR)
2064: THEN
2065: x_vfa_rec.attribute14 := l_vfa_rec.attribute14;
2066: END IF;
2067: IF (x_vfa_rec.attribute15 = OKL_API.G_MISS_CHAR)
2068: THEN
2069: x_vfa_rec.attribute15 := l_vfa_rec.attribute15;
2070: END IF;
2071: IF (x_vfa_rec.created_by = OKL_API.G_MISS_NUM)

Line 2071: IF (x_vfa_rec.created_by = OKL_API.G_MISS_NUM)

2067: IF (x_vfa_rec.attribute15 = OKL_API.G_MISS_CHAR)
2068: THEN
2069: x_vfa_rec.attribute15 := l_vfa_rec.attribute15;
2070: END IF;
2071: IF (x_vfa_rec.created_by = OKL_API.G_MISS_NUM)
2072: THEN
2073: x_vfa_rec.created_by := l_vfa_rec.created_by;
2074: END IF;
2075: IF (x_vfa_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2075: IF (x_vfa_rec.creation_date = OKL_API.G_MISS_DATE)

2071: IF (x_vfa_rec.created_by = OKL_API.G_MISS_NUM)
2072: THEN
2073: x_vfa_rec.created_by := l_vfa_rec.created_by;
2074: END IF;
2075: IF (x_vfa_rec.creation_date = OKL_API.G_MISS_DATE)
2076: THEN
2077: x_vfa_rec.creation_date := l_vfa_rec.creation_date;
2078: END IF;
2079: IF (x_vfa_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2079: IF (x_vfa_rec.last_updated_by = OKL_API.G_MISS_NUM)

2075: IF (x_vfa_rec.creation_date = OKL_API.G_MISS_DATE)
2076: THEN
2077: x_vfa_rec.creation_date := l_vfa_rec.creation_date;
2078: END IF;
2079: IF (x_vfa_rec.last_updated_by = OKL_API.G_MISS_NUM)
2080: THEN
2081: x_vfa_rec.last_updated_by := l_vfa_rec.last_updated_by;
2082: END IF;
2083: IF (x_vfa_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2083: IF (x_vfa_rec.last_update_date = OKL_API.G_MISS_DATE)

2079: IF (x_vfa_rec.last_updated_by = OKL_API.G_MISS_NUM)
2080: THEN
2081: x_vfa_rec.last_updated_by := l_vfa_rec.last_updated_by;
2082: END IF;
2083: IF (x_vfa_rec.last_update_date = OKL_API.G_MISS_DATE)
2084: THEN
2085: x_vfa_rec.last_update_date := l_vfa_rec.last_update_date;
2086: END IF;
2087: IF (x_vfa_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2087: IF (x_vfa_rec.last_update_login = OKL_API.G_MISS_NUM)

2083: IF (x_vfa_rec.last_update_date = OKL_API.G_MISS_DATE)
2084: THEN
2085: x_vfa_rec.last_update_date := l_vfa_rec.last_update_date;
2086: END IF;
2087: IF (x_vfa_rec.last_update_login = OKL_API.G_MISS_NUM)
2088: THEN
2089: x_vfa_rec.last_update_login := l_vfa_rec.last_update_login;
2090: END IF;
2091: --Added by dpsingh for LE uptake

Line 2092: IF (x_vfa_rec.legal_entity_id = OKL_API.G_MISS_NUM)

2088: THEN
2089: x_vfa_rec.last_update_login := l_vfa_rec.last_update_login;
2090: END IF;
2091: --Added by dpsingh for LE uptake
2092: IF (x_vfa_rec.legal_entity_id = OKL_API.G_MISS_NUM)
2093: THEN
2094: x_vfa_rec.legal_entity_id := l_vfa_rec.legal_entity_id;
2095: END IF;
2096: END IF;

Line 2106: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2102: FUNCTION Set_Attributes (
2103: p_vfa_rec IN vfa_rec_type,
2104: x_vfa_rec OUT NOCOPY vfa_rec_type
2105: ) RETURN VARCHAR2 IS
2106: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2107: BEGIN
2108: x_vfa_rec := p_vfa_rec;
2109: x_vfa_rec.OBJECT_VERSION_NUMBER := p_vfa_rec.OBJECT_VERSION_NUMBER + 1;
2110: RETURN(l_return_status);

Line 2113: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2109: x_vfa_rec.OBJECT_VERSION_NUMBER := p_vfa_rec.OBJECT_VERSION_NUMBER + 1;
2110: RETURN(l_return_status);
2111: END Set_Attributes;
2112: BEGIN
2113: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2114: p_init_msg_list,
2115: '_PVT',
2116: x_return_status);
2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2113: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2114: p_init_msg_list,
2115: '_PVT',
2116: x_return_status);
2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2119: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2120: RAISE OKL_API.G_EXCEPTION_ERROR;
2121: END IF;

Line 2118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2114: p_init_msg_list,
2115: '_PVT',
2116: x_return_status);
2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2119: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2120: RAISE OKL_API.G_EXCEPTION_ERROR;
2121: END IF;
2122: --- Setting item attributes

Line 2119: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2115: '_PVT',
2116: x_return_status);
2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2119: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2120: RAISE OKL_API.G_EXCEPTION_ERROR;
2121: END IF;
2122: --- Setting item attributes
2123: l_return_status := Set_Attributes(

Line 2120: RAISE OKL_API.G_EXCEPTION_ERROR;

2116: x_return_status);
2117: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2119: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2120: RAISE OKL_API.G_EXCEPTION_ERROR;
2121: END IF;
2122: --- Setting item attributes
2123: l_return_status := Set_Attributes(
2124: p_vfa_rec, -- IN

Line 2127: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2123: l_return_status := Set_Attributes(
2124: p_vfa_rec, -- IN
2125: l_vfa_rec); -- OUT
2126: --- If any errors happen abort API
2127: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;

Line 2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2124: p_vfa_rec, -- IN
2125: l_vfa_rec); -- OUT
2126: --- If any errors happen abort API
2127: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);

Line 2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2125: l_vfa_rec); -- OUT
2126: --- If any errors happen abort API
2127: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2130: RAISE OKL_API.G_EXCEPTION_ERROR;

2126: --- If any errors happen abort API
2127: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2129: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2135: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2136: RAISE OKL_API.G_EXCEPTION_ERROR;
2137: END IF;

Line 2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2135: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2136: RAISE OKL_API.G_EXCEPTION_ERROR;
2137: END IF;
2138: UPDATE OKL_CONTRACT_ASSET_H

Line 2135: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2131: END IF;
2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2135: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2136: RAISE OKL_API.G_EXCEPTION_ERROR;
2137: END IF;
2138: UPDATE OKL_CONTRACT_ASSET_H
2139: SET ID = l_def_vfa_rec.id,

Line 2136: RAISE OKL_API.G_EXCEPTION_ERROR;

2132: l_return_status := populate_new_record(l_vfa_rec, l_def_vfa_rec);
2133: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2134: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2135: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2136: RAISE OKL_API.G_EXCEPTION_ERROR;
2137: END IF;
2138: UPDATE OKL_CONTRACT_ASSET_H
2139: SET ID = l_def_vfa_rec.id,
2140: MAJOR_VERSION = l_def_vfa_rec.major_version,

Line 2199: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2195: LEGAL_ENTITY_ID = l_def_vfa_rec.legal_entity_id
2196: WHERE ID = l_def_vfa_rec.id;
2197: x_vfa_rec := l_vfa_rec;
2198: x_return_status := l_return_status;
2199: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2200: EXCEPTION
2201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2202: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2203: (

Line 2201: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2197: x_vfa_rec := l_vfa_rec;
2198: x_return_status := l_return_status;
2199: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2200: EXCEPTION
2201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2202: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2203: (
2204: l_api_name,
2205: G_PKG_NAME,

Line 2202: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2198: x_return_status := l_return_status;
2199: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2200: EXCEPTION
2201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2202: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2203: (
2204: l_api_name,
2205: G_PKG_NAME,
2206: 'OKL_API.G_RET_STS_ERROR',

Line 2206: 'OKL_API.G_RET_STS_ERROR',

2202: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2203: (
2204: l_api_name,
2205: G_PKG_NAME,
2206: 'OKL_API.G_RET_STS_ERROR',
2207: x_msg_count,
2208: x_msg_data,
2209: '_PVT'
2210: );

Line 2211: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2207: x_msg_count,
2208: x_msg_data,
2209: '_PVT'
2210: );
2211: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2213: (
2214: l_api_name,
2215: G_PKG_NAME,

Line 2212: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2208: x_msg_data,
2209: '_PVT'
2210: );
2211: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2213: (
2214: l_api_name,
2215: G_PKG_NAME,
2216: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2216: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2213: (
2214: l_api_name,
2215: G_PKG_NAME,
2216: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2217: x_msg_count,
2218: x_msg_data,
2219: '_PVT'
2220: );

Line 2222: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2218: x_msg_data,
2219: '_PVT'
2220: );
2221: WHEN OTHERS THEN
2222: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2223: (
2224: l_api_name,
2225: G_PKG_NAME,
2226: 'OTHERS',

Line 2237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2233: -- update_row for:OKL_CONTRACT_ASSET_HV --
2234: ------------------------------------------
2235: PROCEDURE update_row(
2236: p_api_version IN NUMBER,
2237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2238: x_return_status OUT NOCOPY VARCHAR2,
2239: x_msg_count OUT NOCOPY NUMBER,
2240: x_msg_data OUT NOCOPY VARCHAR2,
2241: p_vfav_rec IN vfav_rec_type,

Line 2246: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2242: x_vfav_rec OUT NOCOPY vfav_rec_type) IS
2243:
2244: l_api_version CONSTANT NUMBER := 1;
2245: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2246: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2247: l_vfav_rec vfav_rec_type := p_vfav_rec;
2248: l_def_vfav_rec vfav_rec_type;
2249: l_db_vfav_rec vfav_rec_type;
2250: l_vfa_rec vfa_rec_type;

Line 2273: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2269: p_vfav_rec IN vfav_rec_type,
2270: x_vfav_rec OUT NOCOPY vfav_rec_type
2271: ) RETURN VARCHAR2 IS
2272: l_row_notfound BOOLEAN := TRUE;
2273: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2274: BEGIN
2275: x_vfav_rec := p_vfav_rec;
2276: l_db_vfav_rec := get_rec(p_vfav_rec, l_return_status);
2277: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 2277: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

2273: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2274: BEGIN
2275: x_vfav_rec := p_vfav_rec;
2276: l_db_vfav_rec := get_rec(p_vfav_rec, l_return_status);
2277: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2278: IF (x_vfav_rec.id = OKL_API.G_MISS_NUM)
2279: THEN
2280: x_vfav_rec.id := l_db_vfav_rec.id;
2281: END IF;

Line 2278: IF (x_vfav_rec.id = OKL_API.G_MISS_NUM)

2274: BEGIN
2275: x_vfav_rec := p_vfav_rec;
2276: l_db_vfav_rec := get_rec(p_vfav_rec, l_return_status);
2277: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2278: IF (x_vfav_rec.id = OKL_API.G_MISS_NUM)
2279: THEN
2280: x_vfav_rec.id := l_db_vfav_rec.id;
2281: END IF;
2282: IF (x_vfav_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 2282: IF (x_vfav_rec.object_version_number = OKL_API.G_MISS_NUM)

2278: IF (x_vfav_rec.id = OKL_API.G_MISS_NUM)
2279: THEN
2280: x_vfav_rec.id := l_db_vfav_rec.id;
2281: END IF;
2282: IF (x_vfav_rec.object_version_number = OKL_API.G_MISS_NUM)
2283: THEN
2284: x_vfav_rec.object_version_number := l_db_vfav_rec.object_version_number;
2285: END IF;
2286: IF (x_vfav_rec.major_version = OKL_API.G_MISS_NUM)

Line 2286: IF (x_vfav_rec.major_version = OKL_API.G_MISS_NUM)

2282: IF (x_vfav_rec.object_version_number = OKL_API.G_MISS_NUM)
2283: THEN
2284: x_vfav_rec.object_version_number := l_db_vfav_rec.object_version_number;
2285: END IF;
2286: IF (x_vfav_rec.major_version = OKL_API.G_MISS_NUM)
2287: THEN
2288: x_vfav_rec.major_version := l_db_vfav_rec.major_version;
2289: END IF;
2290: IF (x_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM)

Line 2290: IF (x_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM)

2286: IF (x_vfav_rec.major_version = OKL_API.G_MISS_NUM)
2287: THEN
2288: x_vfav_rec.major_version := l_db_vfav_rec.major_version;
2289: END IF;
2290: IF (x_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM)
2291: THEN
2292: x_vfav_rec.dnz_chr_id := l_db_vfav_rec.dnz_chr_id;
2293: END IF;
2294: IF (x_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM)

Line 2294: IF (x_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM)

2290: IF (x_vfav_rec.dnz_chr_id = OKL_API.G_MISS_NUM)
2291: THEN
2292: x_vfav_rec.dnz_chr_id := l_db_vfav_rec.dnz_chr_id;
2293: END IF;
2294: IF (x_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM)
2295: THEN
2296: x_vfav_rec.fa_cle_id := l_db_vfav_rec.fa_cle_id;
2297: END IF;
2298: IF (x_vfav_rec.name = OKL_API.G_MISS_CHAR)

Line 2298: IF (x_vfav_rec.name = OKL_API.G_MISS_CHAR)

2294: IF (x_vfav_rec.fa_cle_id = OKL_API.G_MISS_NUM)
2295: THEN
2296: x_vfav_rec.fa_cle_id := l_db_vfav_rec.fa_cle_id;
2297: END IF;
2298: IF (x_vfav_rec.name = OKL_API.G_MISS_CHAR)
2299: THEN
2300: x_vfav_rec.name := l_db_vfav_rec.name;
2301: END IF;
2302: IF (x_vfav_rec.description = OKL_API.G_MISS_CHAR)

Line 2302: IF (x_vfav_rec.description = OKL_API.G_MISS_CHAR)

2298: IF (x_vfav_rec.name = OKL_API.G_MISS_CHAR)
2299: THEN
2300: x_vfav_rec.name := l_db_vfav_rec.name;
2301: END IF;
2302: IF (x_vfav_rec.description = OKL_API.G_MISS_CHAR)
2303: THEN
2304: x_vfav_rec.description := l_db_vfav_rec.description;
2305: END IF;
2306: IF (x_vfav_rec.asset_id = OKL_API.G_MISS_NUM)

Line 2306: IF (x_vfav_rec.asset_id = OKL_API.G_MISS_NUM)

2302: IF (x_vfav_rec.description = OKL_API.G_MISS_CHAR)
2303: THEN
2304: x_vfav_rec.description := l_db_vfav_rec.description;
2305: END IF;
2306: IF (x_vfav_rec.asset_id = OKL_API.G_MISS_NUM)
2307: THEN
2308: x_vfav_rec.asset_id := l_db_vfav_rec.asset_id;
2309: END IF;
2310: IF (x_vfav_rec.asset_number = OKL_API.G_MISS_CHAR)

Line 2310: IF (x_vfav_rec.asset_number = OKL_API.G_MISS_CHAR)

2306: IF (x_vfav_rec.asset_id = OKL_API.G_MISS_NUM)
2307: THEN
2308: x_vfav_rec.asset_id := l_db_vfav_rec.asset_id;
2309: END IF;
2310: IF (x_vfav_rec.asset_number = OKL_API.G_MISS_CHAR)
2311: THEN
2312: x_vfav_rec.asset_number := l_db_vfav_rec.asset_number;
2313: END IF;
2314: IF (x_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR)

Line 2314: IF (x_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR)

2310: IF (x_vfav_rec.asset_number = OKL_API.G_MISS_CHAR)
2311: THEN
2312: x_vfav_rec.asset_number := l_db_vfav_rec.asset_number;
2313: END IF;
2314: IF (x_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR)
2315: THEN
2316: x_vfav_rec.corporate_book := l_db_vfav_rec.corporate_book;
2317: END IF;
2318: IF (x_vfav_rec.life_in_months = OKL_API.G_MISS_NUM)

Line 2318: IF (x_vfav_rec.life_in_months = OKL_API.G_MISS_NUM)

2314: IF (x_vfav_rec.corporate_book = OKL_API.G_MISS_CHAR)
2315: THEN
2316: x_vfav_rec.corporate_book := l_db_vfav_rec.corporate_book;
2317: END IF;
2318: IF (x_vfav_rec.life_in_months = OKL_API.G_MISS_NUM)
2319: THEN
2320: x_vfav_rec.life_in_months := l_db_vfav_rec.life_in_months;
2321: END IF;
2322: IF (x_vfav_rec.original_cost = OKL_API.G_MISS_NUM)

Line 2322: IF (x_vfav_rec.original_cost = OKL_API.G_MISS_NUM)

2318: IF (x_vfav_rec.life_in_months = OKL_API.G_MISS_NUM)
2319: THEN
2320: x_vfav_rec.life_in_months := l_db_vfav_rec.life_in_months;
2321: END IF;
2322: IF (x_vfav_rec.original_cost = OKL_API.G_MISS_NUM)
2323: THEN
2324: x_vfav_rec.original_cost := l_db_vfav_rec.original_cost;
2325: END IF;
2326: IF (x_vfav_rec.cost = OKL_API.G_MISS_NUM)

Line 2326: IF (x_vfav_rec.cost = OKL_API.G_MISS_NUM)

2322: IF (x_vfav_rec.original_cost = OKL_API.G_MISS_NUM)
2323: THEN
2324: x_vfav_rec.original_cost := l_db_vfav_rec.original_cost;
2325: END IF;
2326: IF (x_vfav_rec.cost = OKL_API.G_MISS_NUM)
2327: THEN
2328: x_vfav_rec.cost := l_db_vfav_rec.cost;
2329: END IF;
2330: IF (x_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM)

Line 2330: IF (x_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM)

2326: IF (x_vfav_rec.cost = OKL_API.G_MISS_NUM)
2327: THEN
2328: x_vfav_rec.cost := l_db_vfav_rec.cost;
2329: END IF;
2330: IF (x_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM)
2331: THEN
2332: x_vfav_rec.adjusted_cost := l_db_vfav_rec.adjusted_cost;
2333: END IF;
2334: IF (x_vfav_rec.current_units = OKL_API.G_MISS_NUM)

Line 2334: IF (x_vfav_rec.current_units = OKL_API.G_MISS_NUM)

2330: IF (x_vfav_rec.adjusted_cost = OKL_API.G_MISS_NUM)
2331: THEN
2332: x_vfav_rec.adjusted_cost := l_db_vfav_rec.adjusted_cost;
2333: END IF;
2334: IF (x_vfav_rec.current_units = OKL_API.G_MISS_NUM)
2335: THEN
2336: x_vfav_rec.current_units := l_db_vfav_rec.current_units;
2337: END IF;
2338: IF (x_vfav_rec.new_used = OKL_API.G_MISS_CHAR)

Line 2338: IF (x_vfav_rec.new_used = OKL_API.G_MISS_CHAR)

2334: IF (x_vfav_rec.current_units = OKL_API.G_MISS_NUM)
2335: THEN
2336: x_vfav_rec.current_units := l_db_vfav_rec.current_units;
2337: END IF;
2338: IF (x_vfav_rec.new_used = OKL_API.G_MISS_CHAR)
2339: THEN
2340: x_vfav_rec.new_used := l_db_vfav_rec.new_used;
2341: END IF;
2342: IF (x_vfav_rec.in_service_date = OKL_API.G_MISS_DATE)

Line 2342: IF (x_vfav_rec.in_service_date = OKL_API.G_MISS_DATE)

2338: IF (x_vfav_rec.new_used = OKL_API.G_MISS_CHAR)
2339: THEN
2340: x_vfav_rec.new_used := l_db_vfav_rec.new_used;
2341: END IF;
2342: IF (x_vfav_rec.in_service_date = OKL_API.G_MISS_DATE)
2343: THEN
2344: x_vfav_rec.in_service_date := l_db_vfav_rec.in_service_date;
2345: END IF;
2346: IF (x_vfav_rec.model_number = OKL_API.G_MISS_CHAR)

Line 2346: IF (x_vfav_rec.model_number = OKL_API.G_MISS_CHAR)

2342: IF (x_vfav_rec.in_service_date = OKL_API.G_MISS_DATE)
2343: THEN
2344: x_vfav_rec.in_service_date := l_db_vfav_rec.in_service_date;
2345: END IF;
2346: IF (x_vfav_rec.model_number = OKL_API.G_MISS_CHAR)
2347: THEN
2348: x_vfav_rec.model_number := l_db_vfav_rec.model_number;
2349: END IF;
2350: IF (x_vfav_rec.asset_type = OKL_API.G_MISS_CHAR)

Line 2350: IF (x_vfav_rec.asset_type = OKL_API.G_MISS_CHAR)

2346: IF (x_vfav_rec.model_number = OKL_API.G_MISS_CHAR)
2347: THEN
2348: x_vfav_rec.model_number := l_db_vfav_rec.model_number;
2349: END IF;
2350: IF (x_vfav_rec.asset_type = OKL_API.G_MISS_CHAR)
2351: THEN
2352: x_vfav_rec.asset_type := l_db_vfav_rec.asset_type;
2353: END IF;
2354: IF (x_vfav_rec.salvage_value = OKL_API.G_MISS_NUM)

Line 2354: IF (x_vfav_rec.salvage_value = OKL_API.G_MISS_NUM)

2350: IF (x_vfav_rec.asset_type = OKL_API.G_MISS_CHAR)
2351: THEN
2352: x_vfav_rec.asset_type := l_db_vfav_rec.asset_type;
2353: END IF;
2354: IF (x_vfav_rec.salvage_value = OKL_API.G_MISS_NUM)
2355: THEN
2356: x_vfav_rec.salvage_value := l_db_vfav_rec.salvage_value;
2357: END IF;
2358: IF (x_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM)

Line 2358: IF (x_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM)

2354: IF (x_vfav_rec.salvage_value = OKL_API.G_MISS_NUM)
2355: THEN
2356: x_vfav_rec.salvage_value := l_db_vfav_rec.salvage_value;
2357: END IF;
2358: IF (x_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM)
2359: THEN
2360: x_vfav_rec.percent_salvage_value := l_db_vfav_rec.percent_salvage_value;
2361: END IF;
2362: IF (x_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM)

Line 2362: IF (x_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM)

2358: IF (x_vfav_rec.percent_salvage_value = OKL_API.G_MISS_NUM)
2359: THEN
2360: x_vfav_rec.percent_salvage_value := l_db_vfav_rec.percent_salvage_value;
2361: END IF;
2362: IF (x_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM)
2363: THEN
2364: x_vfav_rec.depreciation_category := l_db_vfav_rec.depreciation_category;
2365: END IF;
2366: IF (x_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE)

Line 2366: IF (x_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE)

2362: IF (x_vfav_rec.depreciation_category = OKL_API.G_MISS_NUM)
2363: THEN
2364: x_vfav_rec.depreciation_category := l_db_vfav_rec.depreciation_category;
2365: END IF;
2366: IF (x_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE)
2367: THEN
2368: x_vfav_rec.deprn_start_date := l_db_vfav_rec.deprn_start_date;
2369: END IF;
2370: IF (x_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR)

Line 2370: IF (x_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR)

2366: IF (x_vfav_rec.deprn_start_date = OKL_API.G_MISS_DATE)
2367: THEN
2368: x_vfav_rec.deprn_start_date := l_db_vfav_rec.deprn_start_date;
2369: END IF;
2370: IF (x_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR)
2371: THEN
2372: x_vfav_rec.deprn_method_code := l_db_vfav_rec.deprn_method_code;
2373: END IF;
2374: IF (x_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)

Line 2374: IF (x_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)

2370: IF (x_vfav_rec.deprn_method_code = OKL_API.G_MISS_CHAR)
2371: THEN
2372: x_vfav_rec.deprn_method_code := l_db_vfav_rec.deprn_method_code;
2373: END IF;
2374: IF (x_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)
2375: THEN
2376: x_vfav_rec.rate_adjustment_factor := l_db_vfav_rec.rate_adjustment_factor;
2377: END IF;
2378: IF (x_vfav_rec.basic_rate = OKL_API.G_MISS_NUM)

Line 2378: IF (x_vfav_rec.basic_rate = OKL_API.G_MISS_NUM)

2374: IF (x_vfav_rec.rate_adjustment_factor = OKL_API.G_MISS_NUM)
2375: THEN
2376: x_vfav_rec.rate_adjustment_factor := l_db_vfav_rec.rate_adjustment_factor;
2377: END IF;
2378: IF (x_vfav_rec.basic_rate = OKL_API.G_MISS_NUM)
2379: THEN
2380: x_vfav_rec.basic_rate := l_db_vfav_rec.basic_rate;
2381: END IF;
2382: IF (x_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM)

Line 2382: IF (x_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM)

2378: IF (x_vfav_rec.basic_rate = OKL_API.G_MISS_NUM)
2379: THEN
2380: x_vfav_rec.basic_rate := l_db_vfav_rec.basic_rate;
2381: END IF;
2382: IF (x_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM)
2383: THEN
2384: x_vfav_rec.adjusted_rate := l_db_vfav_rec.adjusted_rate;
2385: END IF;
2386: IF (x_vfav_rec.start_date_active = OKL_API.G_MISS_DATE)

Line 2386: IF (x_vfav_rec.start_date_active = OKL_API.G_MISS_DATE)

2382: IF (x_vfav_rec.adjusted_rate = OKL_API.G_MISS_NUM)
2383: THEN
2384: x_vfav_rec.adjusted_rate := l_db_vfav_rec.adjusted_rate;
2385: END IF;
2386: IF (x_vfav_rec.start_date_active = OKL_API.G_MISS_DATE)
2387: THEN
2388: x_vfav_rec.start_date_active := l_db_vfav_rec.start_date_active;
2389: END IF;
2390: IF (x_vfav_rec.end_date_active = OKL_API.G_MISS_DATE)

Line 2390: IF (x_vfav_rec.end_date_active = OKL_API.G_MISS_DATE)

2386: IF (x_vfav_rec.start_date_active = OKL_API.G_MISS_DATE)
2387: THEN
2388: x_vfav_rec.start_date_active := l_db_vfav_rec.start_date_active;
2389: END IF;
2390: IF (x_vfav_rec.end_date_active = OKL_API.G_MISS_DATE)
2391: THEN
2392: x_vfav_rec.end_date_active := l_db_vfav_rec.end_date_active;
2393: END IF;
2394: IF (x_vfav_rec.status = OKL_API.G_MISS_CHAR)

Line 2394: IF (x_vfav_rec.status = OKL_API.G_MISS_CHAR)

2390: IF (x_vfav_rec.end_date_active = OKL_API.G_MISS_DATE)
2391: THEN
2392: x_vfav_rec.end_date_active := l_db_vfav_rec.end_date_active;
2393: END IF;
2394: IF (x_vfav_rec.status = OKL_API.G_MISS_CHAR)
2395: THEN
2396: x_vfav_rec.status := l_db_vfav_rec.status;
2397: END IF;
2398: IF (x_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR)

Line 2398: IF (x_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR)

2394: IF (x_vfav_rec.status = OKL_API.G_MISS_CHAR)
2395: THEN
2396: x_vfav_rec.status := l_db_vfav_rec.status;
2397: END IF;
2398: IF (x_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR)
2399: THEN
2400: x_vfav_rec.primary_uom_code := l_db_vfav_rec.primary_uom_code;
2401: END IF;
2402: IF (x_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM)

Line 2402: IF (x_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM)

2398: IF (x_vfav_rec.primary_uom_code = OKL_API.G_MISS_CHAR)
2399: THEN
2400: x_vfav_rec.primary_uom_code := l_db_vfav_rec.primary_uom_code;
2401: END IF;
2402: IF (x_vfav_rec.recoverable_cost = OKL_API.G_MISS_NUM)
2403: THEN
2404: x_vfav_rec.recoverable_cost := l_db_vfav_rec.recoverable_cost;
2405: END IF;
2406: --Bug# 2981308:

Line 2407: IF (x_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM)

2403: THEN
2404: x_vfav_rec.recoverable_cost := l_db_vfav_rec.recoverable_cost;
2405: END IF;
2406: --Bug# 2981308:
2407: IF (x_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM)
2408: THEN
2409: x_vfav_rec.asset_key_id := l_db_vfav_rec.asset_key_id;
2410: END IF;
2411: IF (x_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2411: IF (x_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR)

2407: IF (x_vfav_rec.asset_key_id = OKL_API.G_MISS_NUM)
2408: THEN
2409: x_vfav_rec.asset_key_id := l_db_vfav_rec.asset_key_id;
2410: END IF;
2411: IF (x_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR)
2412: THEN
2413: x_vfav_rec.attribute_category := l_db_vfav_rec.attribute_category;
2414: END IF;
2415: IF (x_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2415: IF (x_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR)

2411: IF (x_vfav_rec.attribute_category = OKL_API.G_MISS_CHAR)
2412: THEN
2413: x_vfav_rec.attribute_category := l_db_vfav_rec.attribute_category;
2414: END IF;
2415: IF (x_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR)
2416: THEN
2417: x_vfav_rec.attribute1 := l_db_vfav_rec.attribute1;
2418: END IF;
2419: IF (x_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2419: IF (x_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR)

2415: IF (x_vfav_rec.attribute1 = OKL_API.G_MISS_CHAR)
2416: THEN
2417: x_vfav_rec.attribute1 := l_db_vfav_rec.attribute1;
2418: END IF;
2419: IF (x_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR)
2420: THEN
2421: x_vfav_rec.attribute2 := l_db_vfav_rec.attribute2;
2422: END IF;
2423: IF (x_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2423: IF (x_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR)

2419: IF (x_vfav_rec.attribute2 = OKL_API.G_MISS_CHAR)
2420: THEN
2421: x_vfav_rec.attribute2 := l_db_vfav_rec.attribute2;
2422: END IF;
2423: IF (x_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR)
2424: THEN
2425: x_vfav_rec.attribute3 := l_db_vfav_rec.attribute3;
2426: END IF;
2427: IF (x_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2427: IF (x_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR)

2423: IF (x_vfav_rec.attribute3 = OKL_API.G_MISS_CHAR)
2424: THEN
2425: x_vfav_rec.attribute3 := l_db_vfav_rec.attribute3;
2426: END IF;
2427: IF (x_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR)
2428: THEN
2429: x_vfav_rec.attribute4 := l_db_vfav_rec.attribute4;
2430: END IF;
2431: IF (x_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2431: IF (x_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR)

2427: IF (x_vfav_rec.attribute4 = OKL_API.G_MISS_CHAR)
2428: THEN
2429: x_vfav_rec.attribute4 := l_db_vfav_rec.attribute4;
2430: END IF;
2431: IF (x_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR)
2432: THEN
2433: x_vfav_rec.attribute5 := l_db_vfav_rec.attribute5;
2434: END IF;
2435: IF (x_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2435: IF (x_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR)

2431: IF (x_vfav_rec.attribute5 = OKL_API.G_MISS_CHAR)
2432: THEN
2433: x_vfav_rec.attribute5 := l_db_vfav_rec.attribute5;
2434: END IF;
2435: IF (x_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR)
2436: THEN
2437: x_vfav_rec.attribute6 := l_db_vfav_rec.attribute6;
2438: END IF;
2439: IF (x_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2439: IF (x_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR)

2435: IF (x_vfav_rec.attribute6 = OKL_API.G_MISS_CHAR)
2436: THEN
2437: x_vfav_rec.attribute6 := l_db_vfav_rec.attribute6;
2438: END IF;
2439: IF (x_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR)
2440: THEN
2441: x_vfav_rec.attribute7 := l_db_vfav_rec.attribute7;
2442: END IF;
2443: IF (x_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2443: IF (x_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR)

2439: IF (x_vfav_rec.attribute7 = OKL_API.G_MISS_CHAR)
2440: THEN
2441: x_vfav_rec.attribute7 := l_db_vfav_rec.attribute7;
2442: END IF;
2443: IF (x_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR)
2444: THEN
2445: x_vfav_rec.attribute8 := l_db_vfav_rec.attribute8;
2446: END IF;
2447: IF (x_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2447: IF (x_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR)

2443: IF (x_vfav_rec.attribute8 = OKL_API.G_MISS_CHAR)
2444: THEN
2445: x_vfav_rec.attribute8 := l_db_vfav_rec.attribute8;
2446: END IF;
2447: IF (x_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR)
2448: THEN
2449: x_vfav_rec.attribute9 := l_db_vfav_rec.attribute9;
2450: END IF;
2451: IF (x_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2451: IF (x_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR)

2447: IF (x_vfav_rec.attribute9 = OKL_API.G_MISS_CHAR)
2448: THEN
2449: x_vfav_rec.attribute9 := l_db_vfav_rec.attribute9;
2450: END IF;
2451: IF (x_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR)
2452: THEN
2453: x_vfav_rec.attribute10 := l_db_vfav_rec.attribute10;
2454: END IF;
2455: IF (x_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2455: IF (x_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR)

2451: IF (x_vfav_rec.attribute10 = OKL_API.G_MISS_CHAR)
2452: THEN
2453: x_vfav_rec.attribute10 := l_db_vfav_rec.attribute10;
2454: END IF;
2455: IF (x_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR)
2456: THEN
2457: x_vfav_rec.attribute11 := l_db_vfav_rec.attribute11;
2458: END IF;
2459: IF (x_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2459: IF (x_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR)

2455: IF (x_vfav_rec.attribute11 = OKL_API.G_MISS_CHAR)
2456: THEN
2457: x_vfav_rec.attribute11 := l_db_vfav_rec.attribute11;
2458: END IF;
2459: IF (x_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR)
2460: THEN
2461: x_vfav_rec.attribute12 := l_db_vfav_rec.attribute12;
2462: END IF;
2463: IF (x_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2463: IF (x_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR)

2459: IF (x_vfav_rec.attribute12 = OKL_API.G_MISS_CHAR)
2460: THEN
2461: x_vfav_rec.attribute12 := l_db_vfav_rec.attribute12;
2462: END IF;
2463: IF (x_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR)
2464: THEN
2465: x_vfav_rec.attribute13 := l_db_vfav_rec.attribute13;
2466: END IF;
2467: IF (x_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2467: IF (x_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR)

2463: IF (x_vfav_rec.attribute13 = OKL_API.G_MISS_CHAR)
2464: THEN
2465: x_vfav_rec.attribute13 := l_db_vfav_rec.attribute13;
2466: END IF;
2467: IF (x_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR)
2468: THEN
2469: x_vfav_rec.attribute14 := l_db_vfav_rec.attribute14;
2470: END IF;
2471: IF (x_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2471: IF (x_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR)

2467: IF (x_vfav_rec.attribute14 = OKL_API.G_MISS_CHAR)
2468: THEN
2469: x_vfav_rec.attribute14 := l_db_vfav_rec.attribute14;
2470: END IF;
2471: IF (x_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR)
2472: THEN
2473: x_vfav_rec.attribute15 := l_db_vfav_rec.attribute15;
2474: END IF;
2475: IF (x_vfav_rec.created_by = OKL_API.G_MISS_NUM)

Line 2475: IF (x_vfav_rec.created_by = OKL_API.G_MISS_NUM)

2471: IF (x_vfav_rec.attribute15 = OKL_API.G_MISS_CHAR)
2472: THEN
2473: x_vfav_rec.attribute15 := l_db_vfav_rec.attribute15;
2474: END IF;
2475: IF (x_vfav_rec.created_by = OKL_API.G_MISS_NUM)
2476: THEN
2477: x_vfav_rec.created_by := l_db_vfav_rec.created_by;
2478: END IF;
2479: IF (x_vfav_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2479: IF (x_vfav_rec.creation_date = OKL_API.G_MISS_DATE)

2475: IF (x_vfav_rec.created_by = OKL_API.G_MISS_NUM)
2476: THEN
2477: x_vfav_rec.created_by := l_db_vfav_rec.created_by;
2478: END IF;
2479: IF (x_vfav_rec.creation_date = OKL_API.G_MISS_DATE)
2480: THEN
2481: x_vfav_rec.creation_date := l_db_vfav_rec.creation_date;
2482: END IF;
2483: IF (x_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2483: IF (x_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM)

2479: IF (x_vfav_rec.creation_date = OKL_API.G_MISS_DATE)
2480: THEN
2481: x_vfav_rec.creation_date := l_db_vfav_rec.creation_date;
2482: END IF;
2483: IF (x_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM)
2484: THEN
2485: x_vfav_rec.last_updated_by := l_db_vfav_rec.last_updated_by;
2486: END IF;
2487: IF (x_vfav_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2487: IF (x_vfav_rec.last_update_date = OKL_API.G_MISS_DATE)

2483: IF (x_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM)
2484: THEN
2485: x_vfav_rec.last_updated_by := l_db_vfav_rec.last_updated_by;
2486: END IF;
2487: IF (x_vfav_rec.last_update_date = OKL_API.G_MISS_DATE)
2488: THEN
2489: x_vfav_rec.last_update_date := l_db_vfav_rec.last_update_date;
2490: END IF;
2491: IF (x_vfav_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2491: IF (x_vfav_rec.last_update_login = OKL_API.G_MISS_NUM)

2487: IF (x_vfav_rec.last_update_date = OKL_API.G_MISS_DATE)
2488: THEN
2489: x_vfav_rec.last_update_date := l_db_vfav_rec.last_update_date;
2490: END IF;
2491: IF (x_vfav_rec.last_update_login = OKL_API.G_MISS_NUM)
2492: THEN
2493: x_vfav_rec.last_update_login := l_db_vfav_rec.last_update_login;
2494: END IF;
2495: --Added by dpsingh for LE uptake

Line 2496: IF (x_vfav_rec.legal_entity_id = OKL_API.G_MISS_NUM)

2492: THEN
2493: x_vfav_rec.last_update_login := l_db_vfav_rec.last_update_login;
2494: END IF;
2495: --Added by dpsingh for LE uptake
2496: IF (x_vfav_rec.legal_entity_id = OKL_API.G_MISS_NUM)
2497: THEN
2498: x_vfav_rec.legal_entity_id := l_db_vfav_rec.legal_entity_id;
2499: END IF;
2500: END IF;

Line 2510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2506: FUNCTION Set_Attributes (
2507: p_vfav_rec IN vfav_rec_type,
2508: x_vfav_rec OUT NOCOPY vfav_rec_type
2509: ) RETURN VARCHAR2 IS
2510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2511: BEGIN
2512: x_vfav_rec := p_vfav_rec;
2513: RETURN(l_return_status);
2514: END Set_Attributes;

Line 2516: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2512: x_vfav_rec := p_vfav_rec;
2513: RETURN(l_return_status);
2514: END Set_Attributes;
2515: BEGIN
2516: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2517: G_PKG_NAME,
2518: p_init_msg_list,
2519: l_api_version,
2520: p_api_version,

Line 2523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2519: l_api_version,
2520: p_api_version,
2521: '_PVT',
2522: x_return_status);
2523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_ERROR;
2527: END IF;

Line 2524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2520: p_api_version,
2521: '_PVT',
2522: x_return_status);
2523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_ERROR;
2527: END IF;
2528: --- Setting item attributes

Line 2525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2521: '_PVT',
2522: x_return_status);
2523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_ERROR;
2527: END IF;
2528: --- Setting item attributes
2529: l_return_status := Set_Attributes(

Line 2526: RAISE OKL_API.G_EXCEPTION_ERROR;

2522: x_return_status);
2523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_ERROR;
2527: END IF;
2528: --- Setting item attributes
2529: l_return_status := Set_Attributes(
2530: p_vfav_rec, -- IN

Line 2533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2529: l_return_status := Set_Attributes(
2530: p_vfav_rec, -- IN
2531: x_vfav_rec); -- OUT
2532: --- If any errors happen abort API
2533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;

Line 2534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2530: p_vfav_rec, -- IN
2531: x_vfav_rec); -- OUT
2532: --- If any errors happen abort API
2533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);

Line 2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2531: x_vfav_rec); -- OUT
2532: --- If any errors happen abort API
2533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2536: RAISE OKL_API.G_EXCEPTION_ERROR;

2532: --- If any errors happen abort API
2533: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2535: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2542: RAISE OKL_API.G_EXCEPTION_ERROR;
2543: END IF;

Line 2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2536: RAISE OKL_API.G_EXCEPTION_ERROR;
2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2542: RAISE OKL_API.G_EXCEPTION_ERROR;
2543: END IF;
2544: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);

Line 2541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2537: END IF;
2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2542: RAISE OKL_API.G_EXCEPTION_ERROR;
2543: END IF;
2544: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
2545: --- Validate all non-missing attributes (Item Level Validation)

Line 2542: RAISE OKL_API.G_EXCEPTION_ERROR;

2538: l_return_status := populate_new_record(l_vfav_rec, l_def_vfav_rec);
2539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2542: RAISE OKL_API.G_EXCEPTION_ERROR;
2543: END IF;
2544: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
2545: --- Validate all non-missing attributes (Item Level Validation)
2546: l_return_status := Validate_Attributes(l_def_vfav_rec);

Line 2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2544: l_def_vfav_rec := fill_who_columns(l_def_vfav_rec);
2545: --- Validate all non-missing attributes (Item Level Validation)
2546: l_return_status := Validate_Attributes(l_def_vfav_rec);
2547: --- If any errors happen abort API
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;

Line 2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2545: --- Validate all non-missing attributes (Item Level Validation)
2546: l_return_status := Validate_Attributes(l_def_vfav_rec);
2547: --- If any errors happen abort API
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);

Line 2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2546: l_return_status := Validate_Attributes(l_def_vfav_rec);
2547: --- If any errors happen abort API
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2551: RAISE OKL_API.G_EXCEPTION_ERROR;

2547: --- If any errors happen abort API
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;

Line 2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559: -----------------------------------------

Line 2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2552: END IF;
2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559: -----------------------------------------
2560: -- Move VIEW record to "Child" records --

Line 2557: RAISE OKL_API.G_EXCEPTION_ERROR;

2553: l_return_status := Validate_Record(l_def_vfav_rec);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559: -----------------------------------------
2560: -- Move VIEW record to "Child" records --
2561: -----------------------------------------

Line 2575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2571: x_msg_data,
2572: l_vfa_rec,
2573: lx_vfa_rec
2574: );
2575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2577: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2578: RAISE OKL_API.G_EXCEPTION_ERROR;
2579: END IF;

Line 2576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2572: l_vfa_rec,
2573: lx_vfa_rec
2574: );
2575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2577: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2578: RAISE OKL_API.G_EXCEPTION_ERROR;
2579: END IF;
2580: migrate(lx_vfa_rec, l_def_vfav_rec);

Line 2577: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2573: lx_vfa_rec
2574: );
2575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2577: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2578: RAISE OKL_API.G_EXCEPTION_ERROR;
2579: END IF;
2580: migrate(lx_vfa_rec, l_def_vfav_rec);
2581: x_vfav_rec := l_def_vfav_rec;

Line 2578: RAISE OKL_API.G_EXCEPTION_ERROR;

2574: );
2575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2577: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2578: RAISE OKL_API.G_EXCEPTION_ERROR;
2579: END IF;
2580: migrate(lx_vfa_rec, l_def_vfav_rec);
2581: x_vfav_rec := l_def_vfav_rec;
2582: x_return_status := l_return_status;

Line 2583: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2579: END IF;
2580: migrate(lx_vfa_rec, l_def_vfav_rec);
2581: x_vfav_rec := l_def_vfav_rec;
2582: x_return_status := l_return_status;
2583: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2584: EXCEPTION
2585: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2586: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2587: (

Line 2585: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2581: x_vfav_rec := l_def_vfav_rec;
2582: x_return_status := l_return_status;
2583: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2584: EXCEPTION
2585: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2586: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,

Line 2586: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2582: x_return_status := l_return_status;
2583: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2584: EXCEPTION
2585: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2586: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,
2590: 'OKL_API.G_RET_STS_ERROR',

Line 2590: 'OKL_API.G_RET_STS_ERROR',

2586: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2587: (
2588: l_api_name,
2589: G_PKG_NAME,
2590: 'OKL_API.G_RET_STS_ERROR',
2591: x_msg_count,
2592: x_msg_data,
2593: '_PVT'
2594: );

Line 2595: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2591: x_msg_count,
2592: x_msg_data,
2593: '_PVT'
2594: );
2595: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2596: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2597: (
2598: l_api_name,
2599: G_PKG_NAME,

Line 2596: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2592: x_msg_data,
2593: '_PVT'
2594: );
2595: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2596: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2597: (
2598: l_api_name,
2599: G_PKG_NAME,
2600: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2600: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2596: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2597: (
2598: l_api_name,
2599: G_PKG_NAME,
2600: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2601: x_msg_count,
2602: x_msg_data,
2603: '_PVT'
2604: );

Line 2606: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2602: x_msg_data,
2603: '_PVT'
2604: );
2605: WHEN OTHERS THEN
2606: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2607: (
2608: l_api_name,
2609: G_PKG_NAME,
2610: 'OTHERS',

Line 2621: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2617: -- PL/SQL TBL update_row for:vfav_tbl --
2618: ----------------------------------------
2619: PROCEDURE update_row(
2620: p_api_version IN NUMBER,
2621: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2622: x_return_status OUT NOCOPY VARCHAR2,
2623: x_msg_count OUT NOCOPY NUMBER,
2624: x_msg_data OUT NOCOPY VARCHAR2,
2625: p_vfav_tbl IN vfav_tbl_type,

Line 2632: OKL_API.init_msg_list(p_init_msg_list);

2628: l_api_version CONSTANT NUMBER := 1;
2629: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2630: i NUMBER := 0;
2631: BEGIN
2632: OKL_API.init_msg_list(p_init_msg_list);
2633: -- Make sure PL/SQL table has records in it before passing
2634: IF (p_vfav_tbl.COUNT > 0) THEN
2635: i := p_vfav_tbl.FIRST;
2636: LOOP

Line 2649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2645: EXIT WHEN (i = p_vfav_tbl.LAST);
2646: i := p_vfav_tbl.NEXT(i);
2647: END LOOP;
2648: END IF;
2649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2650: EXCEPTION
2651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2653: (

Line 2651: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2647: END LOOP;
2648: END IF;
2649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2650: EXCEPTION
2651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2653: (
2654: l_api_name,
2655: G_PKG_NAME,

Line 2652: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2648: END IF;
2649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2650: EXCEPTION
2651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2653: (
2654: l_api_name,
2655: G_PKG_NAME,
2656: 'OKL_API.G_RET_STS_ERROR',

Line 2656: 'OKL_API.G_RET_STS_ERROR',

2652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2653: (
2654: l_api_name,
2655: G_PKG_NAME,
2656: 'OKL_API.G_RET_STS_ERROR',
2657: x_msg_count,
2658: x_msg_data,
2659: '_PVT'
2660: );

Line 2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2657: x_msg_count,
2658: x_msg_data,
2659: '_PVT'
2660: );
2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2663: (
2664: l_api_name,
2665: G_PKG_NAME,

Line 2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2658: x_msg_data,
2659: '_PVT'
2660: );
2661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2663: (
2664: l_api_name,
2665: G_PKG_NAME,
2666: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2666: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2662: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2663: (
2664: l_api_name,
2665: G_PKG_NAME,
2666: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2667: x_msg_count,
2668: x_msg_data,
2669: '_PVT'
2670: );

Line 2672: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2668: x_msg_data,
2669: '_PVT'
2670: );
2671: WHEN OTHERS THEN
2672: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2673: (
2674: l_api_name,
2675: G_PKG_NAME,
2676: 'OTHERS',

Line 2689: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2685: ------------------------------------------
2686: -- delete_row for:OKL_CONTRACT_ASSET_HV --
2687: ------------------------------------------
2688: PROCEDURE delete_row(
2689: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2690: x_return_status OUT NOCOPY VARCHAR2,
2691: x_msg_count OUT NOCOPY NUMBER,
2692: x_msg_data OUT NOCOPY VARCHAR2,
2693: p_vfa_rec IN vfa_rec_type) IS

Line 2697: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2693: p_vfa_rec IN vfa_rec_type) IS
2694:
2695: l_api_version CONSTANT NUMBER := 1;
2696: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2697: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2698: l_vfa_rec vfa_rec_type := p_vfa_rec;
2699: l_row_notfound BOOLEAN := TRUE;
2700: BEGIN
2701: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2701: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2697: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2698: l_vfa_rec vfa_rec_type := p_vfa_rec;
2699: l_row_notfound BOOLEAN := TRUE;
2700: BEGIN
2701: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2702: p_init_msg_list,
2703: '_PVT',
2704: x_return_status);
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2701: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2702: p_init_msg_list,
2703: '_PVT',
2704: x_return_status);
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;

Line 2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2702: p_init_msg_list,
2703: '_PVT',
2704: x_return_status);
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:

Line 2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2703: '_PVT',
2704: x_return_status);
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:
2711: DELETE FROM OKL_CONTRACT_ASSET_H

Line 2708: RAISE OKL_API.G_EXCEPTION_ERROR;

2704: x_return_status);
2705: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2707: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2708: RAISE OKL_API.G_EXCEPTION_ERROR;
2709: END IF;
2710:
2711: DELETE FROM OKL_CONTRACT_ASSET_H
2712: WHERE ID = p_vfa_rec.id;

Line 2714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2710:
2711: DELETE FROM OKL_CONTRACT_ASSET_H
2712: WHERE ID = p_vfa_rec.id;
2713: x_return_status := l_return_status;
2714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2715: EXCEPTION
2716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2717: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2718: (

Line 2716: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2712: WHERE ID = p_vfa_rec.id;
2713: x_return_status := l_return_status;
2714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2715: EXCEPTION
2716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2717: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2718: (
2719: l_api_name,
2720: G_PKG_NAME,

Line 2717: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2713: x_return_status := l_return_status;
2714: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2715: EXCEPTION
2716: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2717: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2718: (
2719: l_api_name,
2720: G_PKG_NAME,
2721: 'OKL_API.G_RET_STS_ERROR',

Line 2721: 'OKL_API.G_RET_STS_ERROR',

2717: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2718: (
2719: l_api_name,
2720: G_PKG_NAME,
2721: 'OKL_API.G_RET_STS_ERROR',
2722: x_msg_count,
2723: x_msg_data,
2724: '_PVT'
2725: );

Line 2726: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2722: x_msg_count,
2723: x_msg_data,
2724: '_PVT'
2725: );
2726: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2727: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2728: (
2729: l_api_name,
2730: G_PKG_NAME,

Line 2727: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2723: x_msg_data,
2724: '_PVT'
2725: );
2726: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2727: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2728: (
2729: l_api_name,
2730: G_PKG_NAME,
2731: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2731: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2727: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2728: (
2729: l_api_name,
2730: G_PKG_NAME,
2731: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2732: x_msg_count,
2733: x_msg_data,
2734: '_PVT'
2735: );

Line 2737: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2733: x_msg_data,
2734: '_PVT'
2735: );
2736: WHEN OTHERS THEN
2737: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2738: (
2739: l_api_name,
2740: G_PKG_NAME,
2741: 'OTHERS',

Line 2752: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2748: -- delete_row for:OKL_CONTRACT_ASSET_HV --
2749: ------------------------------------------
2750: PROCEDURE delete_row(
2751: p_api_version IN NUMBER,
2752: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2753: x_return_status OUT NOCOPY VARCHAR2,
2754: x_msg_count OUT NOCOPY NUMBER,
2755: x_msg_data OUT NOCOPY VARCHAR2,
2756: p_vfav_rec IN vfav_rec_type) IS

Line 2760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2756: p_vfav_rec IN vfav_rec_type) IS
2757:
2758: l_api_version CONSTANT NUMBER := 1;
2759: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2761: l_vfav_rec vfav_rec_type := p_vfav_rec;
2762: l_vfa_rec vfa_rec_type;
2763: BEGIN
2764: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2764: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2761: l_vfav_rec vfav_rec_type := p_vfav_rec;
2762: l_vfa_rec vfa_rec_type;
2763: BEGIN
2764: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2765: G_PKG_NAME,
2766: p_init_msg_list,
2767: l_api_version,
2768: p_api_version,

Line 2771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2767: l_api_version,
2768: p_api_version,
2769: '_PVT',
2770: x_return_status);
2771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;

Line 2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2768: p_api_version,
2769: '_PVT',
2770: x_return_status);
2771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776: -----------------------------------------

Line 2773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2769: '_PVT',
2770: x_return_status);
2771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776: -----------------------------------------
2777: -- Move VIEW record to "Child" records --

Line 2774: RAISE OKL_API.G_EXCEPTION_ERROR;

2770: x_return_status);
2771: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2773: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2774: RAISE OKL_API.G_EXCEPTION_ERROR;
2775: END IF;
2776: -----------------------------------------
2777: -- Move VIEW record to "Child" records --
2778: -----------------------------------------

Line 2790: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2786: x_msg_count,
2787: x_msg_data,
2788: l_vfa_rec
2789: );
2790: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2793: RAISE OKL_API.G_EXCEPTION_ERROR;
2794: END IF;

Line 2791: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2787: x_msg_data,
2788: l_vfa_rec
2789: );
2790: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2793: RAISE OKL_API.G_EXCEPTION_ERROR;
2794: END IF;
2795: x_return_status := l_return_status;

Line 2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2788: l_vfa_rec
2789: );
2790: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2793: RAISE OKL_API.G_EXCEPTION_ERROR;
2794: END IF;
2795: x_return_status := l_return_status;
2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2793: RAISE OKL_API.G_EXCEPTION_ERROR;

2789: );
2790: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2793: RAISE OKL_API.G_EXCEPTION_ERROR;
2794: END IF;
2795: x_return_status := l_return_status;
2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2797: EXCEPTION

Line 2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2792: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2793: RAISE OKL_API.G_EXCEPTION_ERROR;
2794: END IF;
2795: x_return_status := l_return_status;
2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2797: EXCEPTION
2798: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2800: (

Line 2798: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2794: END IF;
2795: x_return_status := l_return_status;
2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2797: EXCEPTION
2798: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2800: (
2801: l_api_name,
2802: G_PKG_NAME,

Line 2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2795: x_return_status := l_return_status;
2796: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2797: EXCEPTION
2798: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2800: (
2801: l_api_name,
2802: G_PKG_NAME,
2803: 'OKL_API.G_RET_STS_ERROR',

Line 2803: 'OKL_API.G_RET_STS_ERROR',

2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2800: (
2801: l_api_name,
2802: G_PKG_NAME,
2803: 'OKL_API.G_RET_STS_ERROR',
2804: x_msg_count,
2805: x_msg_data,
2806: '_PVT'
2807: );

Line 2808: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2804: x_msg_count,
2805: x_msg_data,
2806: '_PVT'
2807: );
2808: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2810: (
2811: l_api_name,
2812: G_PKG_NAME,

Line 2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2805: x_msg_data,
2806: '_PVT'
2807: );
2808: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2810: (
2811: l_api_name,
2812: G_PKG_NAME,
2813: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2813: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2809: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2810: (
2811: l_api_name,
2812: G_PKG_NAME,
2813: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2814: x_msg_count,
2815: x_msg_data,
2816: '_PVT'
2817: );

Line 2819: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2815: x_msg_data,
2816: '_PVT'
2817: );
2818: WHEN OTHERS THEN
2819: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2820: (
2821: l_api_name,
2822: G_PKG_NAME,
2823: 'OTHERS',

Line 2834: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2830: -- PL/SQL TBL delete_row for:OKL_CONTRACT_ASSET_HV --
2831: -----------------------------------------------------
2832: PROCEDURE delete_row(
2833: p_api_version IN NUMBER,
2834: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2835: x_return_status OUT NOCOPY VARCHAR2,
2836: x_msg_count OUT NOCOPY NUMBER,
2837: x_msg_data OUT NOCOPY VARCHAR2,
2838: p_vfav_tbl IN vfav_tbl_type) IS

Line 2844: OKL_API.init_msg_list(p_init_msg_list);

2840: l_api_version CONSTANT NUMBER := 1;
2841: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2842: i NUMBER := 0;
2843: BEGIN
2844: OKL_API.init_msg_list(p_init_msg_list);
2845: -- Make sure PL/SQL table has records in it before passing
2846: IF (p_vfav_tbl.COUNT > 0) THEN
2847: i := p_vfav_tbl.FIRST;
2848: LOOP

Line 2860: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2856: EXIT WHEN (i = p_vfav_tbl.LAST);
2857: i := p_vfav_tbl.NEXT(i);
2858: END LOOP;
2859: END IF;
2860: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2861: EXCEPTION
2862: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (

Line 2862: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2858: END LOOP;
2859: END IF;
2860: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2861: EXCEPTION
2862: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,

Line 2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2859: END IF;
2860: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2861: EXCEPTION
2862: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'OKL_API.G_RET_STS_ERROR',

Line 2867: 'OKL_API.G_RET_STS_ERROR',

2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'OKL_API.G_RET_STS_ERROR',
2868: x_msg_count,
2869: x_msg_data,
2870: '_PVT'
2871: );

Line 2872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2868: x_msg_count,
2869: x_msg_data,
2870: '_PVT'
2871: );
2872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2874: (
2875: l_api_name,
2876: G_PKG_NAME,

Line 2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2869: x_msg_data,
2870: '_PVT'
2871: );
2872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2874: (
2875: l_api_name,
2876: G_PKG_NAME,
2877: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2877: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2874: (
2875: l_api_name,
2876: G_PKG_NAME,
2877: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2878: x_msg_count,
2879: x_msg_data,
2880: '_PVT'
2881: );

Line 2883: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2879: x_msg_data,
2880: '_PVT'
2881: );
2882: WHEN OTHERS THEN
2883: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2884: (
2885: l_api_name,
2886: G_PKG_NAME,
2887: 'OTHERS',