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_TQL_PVT dependencies on OKL_API

Line 232: IF (p_tqlv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND

228: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
229: BEGIN
230: -- initialize return status
231: x_return_status := OKC_API.G_RET_STS_SUCCESS;
232: IF (p_tqlv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
233: p_tqlv_rec.currency_conversion_type IS NOT NULL) THEN
234: -- check from currency values using the generic okl_util.validate_currency_code
235: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_tqlv_rec.currency_conversion_type);
236: IF (l_return_status <> OKC_API.G_TRUE) THEN

Line 281: x_return_status := OKL_API.G_RET_STS_SUCCESS;

277: WHERE id = p_id);
278:
279: BEGIN
280: -- initialize return status
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: -- This is an optional Column.
283: IF (p_tqlv_rec.split_kle_id = OKL_API.G_MISS_NUM) OR
284: (p_tqlv_rec.split_kle_id IS NULL) THEN
285: RAISE G_EXCEPTION_STOP_VALIDATION;

Line 283: IF (p_tqlv_rec.split_kle_id = OKL_API.G_MISS_NUM) OR

279: BEGIN
280: -- initialize return status
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: -- This is an optional Column.
283: IF (p_tqlv_rec.split_kle_id = OKL_API.G_MISS_NUM) OR
284: (p_tqlv_rec.split_kle_id IS NULL) THEN
285: RAISE G_EXCEPTION_STOP_VALIDATION;
286: END IF;
287: -- Enforce Foreign Key

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

301: null;
302: WHEN G_EXCEPTION_HALT_VALIDATION then
303: -- We are here b'cause we have no parent record
304: -- store SQL error message on message stack
305: OKL_API.set_message(p_app_name => G_APP_NAME,
306: p_msg_name => G_NO_PARENT_RECORD,
307: p_token1 => g_col_name_token,
308: p_token1_value => 'Split_kle_id');
309: -- If the cursor is open then it has to be closed

Line 314: x_return_status := OKL_API.G_RET_STS_ERROR;

310: IF c_split_kle_id%ISOPEN THEN
311: CLOSE c_split_kle_id;
312: END IF;
313: -- notify caller of an error
314: x_return_status := OKL_API.G_RET_STS_ERROR;
315: WHEN OTHERS THEN
316: -- store SQL error message on message stack
317: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
318: p_msg_name => G_UNEXPECTED_ERROR,

Line 327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

323: IF c_split_kle_id%ISOPEN THEN
324: CLOSE c_split_kle_id;
325: END IF;
326: -- notify caller of an error as UNEXPETED error
327: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
328: END validate_split_kle_id;
329: ------------------------------------
330: -- PROCEDURE validate_org_id
331: ------------------------------------

Line 522: AND p_tqlv_rec.sty_id <> OKL_API.G_MISS_NUM THEN

518: WHERE ID = p_tqlv_rec.sty_id;
519:
520: BEGIN
521: IF p_tqlv_rec.sty_id IS NOT NULL
522: AND p_tqlv_rec.sty_id <> OKL_API.G_MISS_NUM THEN
523:
524: OPEN okl_sty_fk_csr;
525: FETCH okl_sty_fk_csr INTO l_dummy_var;
526: CLOSE okl_sty_fk_csr;

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

915: IF okl_qtev_fk_csr%ISOPEN THEN
916: CLOSE okl_qtev_fk_csr;
917: END IF;
918:
919: OKL_API.set_message(p_app_name => G_APP_NAME,
920: p_msg_name => G_UNEXPECTED_ERROR,
921: p_token1 => G_SQLCODE_TOKEN,
922: p_token1_value => SQLCODE,
923: p_token2 => G_SQLERRM_TOKEN,

Line 991: x_return_status := OKL_API.G_RET_STS_SUCCESS;

987: p_tqlv_rec IN tqlv_rec_type) IS
988:
989: BEGIN
990:
991: x_return_status := OKL_API.G_RET_STS_SUCCESS;
992:
993: -- If amount not passed then raise error
994: IF p_tqlv_rec.amount = OKL_API.G_MISS_NUM
995: OR p_tqlv_rec.amount IS NULL THEN

Line 994: IF p_tqlv_rec.amount = OKL_API.G_MISS_NUM

990:
991: x_return_status := OKL_API.G_RET_STS_SUCCESS;
992:
993: -- If amount not passed then raise error
994: IF p_tqlv_rec.amount = OKL_API.G_MISS_NUM
995: OR p_tqlv_rec.amount IS NULL THEN
996:
997: OKC_API.set_message(
998: p_app_name => G_APP_NAME,

Line 1003: x_return_status := OKL_API.G_RET_STS_ERROR;

999: p_msg_name => G_REQUIRED_VALUE,
1000: p_token1 => G_COL_NAME_TOKEN,
1001: p_token1_value => 'amount');
1002:
1003: x_return_status := OKL_API.G_RET_STS_ERROR;
1004:
1005: RAISE G_EXCEPTION_HALT_VALIDATION;
1006:
1007: END IF;

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

1012: NULL;
1013:
1014: WHEN OTHERS THEN
1015:
1016: OKL_API.set_message(p_app_name => G_APP_NAME,
1017: p_msg_name => G_UNEXPECTED_ERROR,
1018: p_token1 => G_SQLCODE_TOKEN,
1019: p_token1_value => SQLCODE,
1020: p_token2 => G_SQLERRM_TOKEN,

Line 1023: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1019: p_token1_value => SQLCODE,
1020: p_token2 => G_SQLERRM_TOKEN,
1021: p_token2_value => SQLERRM);
1022:
1023: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1024:
1025: END validate_amount;
1026:
1027:

Line 1716: IF (l_tqlv_rec.due_date = OKL_API.G_MISS_DATE) THEN

1712: END IF;
1713: -- BAKUCHIB 2667636 End
1714: -- PAGARG Bug 4161133 Start
1715: -- null out defaults for new column DUE_DATE
1716: IF (l_tqlv_rec.due_date = OKL_API.G_MISS_DATE) THEN
1717: l_tqlv_rec.due_date := NULL;
1718: END IF;
1719: -- PAGARG Bug 4161133 End
1720: -- rmunjulu Sales_Tax_Enhancement

Line 1721: IF (l_tqlv_rec.try_id = OKL_API.G_MISS_NUM) THEN

1717: l_tqlv_rec.due_date := NULL;
1718: END IF;
1719: -- PAGARG Bug 4161133 End
1720: -- rmunjulu Sales_Tax_Enhancement
1721: IF (l_tqlv_rec.try_id = OKL_API.G_MISS_NUM) THEN
1722: l_tqlv_rec.try_id := NULL;
1723: END IF;
1724: RETURN(l_tqlv_rec);
1725: END null_out_defaults;

Line 2256: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2253: i NUMBER := 0;
2254: -- Begin Post-Generation Change
2255: -- overall error status
2256: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2257: -- End Post-Generation Change
2258:
2259: BEGIN
2260: OKC_API.init_msg_list(p_init_msg_list);

Line 2274: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2270: x_msg_data => x_msg_data,
2271: p_tqlv_rec => p_tqlv_tbl(i));
2272: -- Begin Post-Generation Change
2273: -- store the highest degree of error
2274: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2276: l_overall_status := x_return_status;
2277: END IF;
2278: END IF;

Line 2275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2271: p_tqlv_rec => p_tqlv_tbl(i));
2272: -- Begin Post-Generation Change
2273: -- store the highest degree of error
2274: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2276: l_overall_status := x_return_status;
2277: END IF;
2278: END IF;
2279: -- End Post-Generation Change

Line 2906: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2902: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2903: i NUMBER := 0;
2904: -- Begin Post-Generation Change
2905: -- overall error status
2906: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2907: -- End Post-Generation Change
2908: BEGIN
2909: OKC_API.init_msg_list(p_init_msg_list);
2910: -- Make sure PL/SQL table has records in it before passing

Line 2924: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2920: p_tqlv_rec => p_tqlv_tbl(i),
2921: x_tqlv_rec => x_tqlv_tbl(i));
2922: -- Begin Post-Generation Change
2923: -- store the highest degree of error
2924: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2925: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2926: l_overall_status := x_return_status;
2927: END IF;
2928: END IF;

Line 2925: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2921: x_tqlv_rec => x_tqlv_tbl(i));
2922: -- Begin Post-Generation Change
2923: -- store the highest degree of error
2924: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2925: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2926: l_overall_status := x_return_status;
2927: END IF;
2928: END IF;
2929: -- End Post-Generation Change

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

2991: x_tqlv_tbl OUT NOCOPY tqlv_tbl_type) IS
2992:
2993: l_api_version CONSTANT NUMBER := 1;
2994: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_bulk';
2995: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2996: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2997:
2998: -- sechawla 8-may-09 Bug# 8429670 -- Added
2999: CURSOR get_languages IS

Line 2996: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2992:
2993: l_api_version CONSTANT NUMBER := 1;
2994: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_bulk';
2995: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2996: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2997:
2998: -- sechawla 8-may-09 Bug# 8429670 -- Added
2999: CURSOR get_languages IS
3000: SELECT *

Line 3090: OKL_API.init_msg_list(p_init_msg_list);

3086: l_conc_reg_id NUMBER(15);
3087: l_lang VARCHAR2(12);
3088:
3089: BEGIN
3090: OKL_API.init_msg_list(p_init_msg_list);
3091: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3092: G_PKG_NAME,
3093: p_init_msg_list,
3094: l_api_version,

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

3087: l_lang VARCHAR2(12);
3088:
3089: BEGIN
3090: OKL_API.init_msg_list(p_init_msg_list);
3091: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3092: G_PKG_NAME,
3093: p_init_msg_list,
3094: l_api_version,
3095: p_api_version,

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

3094: l_api_version,
3095: p_api_version,
3096: '_PVT',
3097: x_return_status);
3098: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3101: RAISE OKL_API.G_EXCEPTION_ERROR;
3102: END IF;

Line 3099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3095: p_api_version,
3096: '_PVT',
3097: x_return_status);
3098: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3101: RAISE OKL_API.G_EXCEPTION_ERROR;
3102: END IF;
3103:

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

3096: '_PVT',
3097: x_return_status);
3098: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3101: RAISE OKL_API.G_EXCEPTION_ERROR;
3102: END IF;
3103:
3104: i := p_tqlv_tbl.FIRST;

Line 3101: RAISE OKL_API.G_EXCEPTION_ERROR;

3097: x_return_status);
3098: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3099: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3100: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3101: RAISE OKL_API.G_EXCEPTION_ERROR;
3102: END IF;
3103:
3104: i := p_tqlv_tbl.FIRST;
3105: j :=0;

Line 3128: OR l_tqlv_rec.currency_code = OKL_API.G_MISS_CHAR THEN

3124: l_tqlv_rec.last_update_login := l_login_id;
3125:
3126: l_tqlv_rec.currency_conversion_code := l_curr_code;
3127: IF l_tqlv_rec.currency_code IS NULL
3128: OR l_tqlv_rec.currency_code = OKL_API.G_MISS_CHAR THEN
3129: l_tqlv_rec.currency_code := l_tqlv_rec.currency_conversion_code;
3130: END IF;
3131:
3132: IF l_tqlv_rec.defaulted_yn IS NULL

Line 3133: OR l_tqlv_rec.defaulted_yn = OKL_API.G_MISS_CHAR THEN

3129: l_tqlv_rec.currency_code := l_tqlv_rec.currency_conversion_code;
3130: END IF;
3131:
3132: IF l_tqlv_rec.defaulted_yn IS NULL
3133: OR l_tqlv_rec.defaulted_yn = OKL_API.G_MISS_CHAR THEN
3134: l_tqlv_rec.defaulted_yn := 'N';
3135: END IF;
3136:
3137: -- Default the ORG ID if a value is not passed

Line 3139: OR l_tqlv_rec.org_id = OKL_API.G_MISS_NUM THEN

3135: END IF;
3136:
3137: -- Default the ORG ID if a value is not passed
3138: IF l_tqlv_rec.org_id IS NULL
3139: OR l_tqlv_rec.org_id = OKL_API.G_MISS_NUM THEN
3140: l_tqlv_rec.org_id := l_org_id;
3141: END IF;
3142:
3143: IF l_conc_req_id = -1

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

3168: l_tqlv_rec.sfwt_flag := 'N';
3169:
3170: l_return_status := Validate_Attributes(l_tqlv_rec);
3171: -- If any errors happen abort API
3172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3175: RAISE OKL_API.G_EXCEPTION_ERROR;
3176: END IF;

Line 3173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3169:
3170: l_return_status := Validate_Attributes(l_tqlv_rec);
3171: -- If any errors happen abort API
3172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3175: RAISE OKL_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:

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

3170: l_return_status := Validate_Attributes(l_tqlv_rec);
3171: -- If any errors happen abort API
3172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3175: RAISE OKL_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:
3178: l_return_status := Validate_Record(l_tqlv_rec);

Line 3175: RAISE OKL_API.G_EXCEPTION_ERROR;

3171: -- If any errors happen abort API
3172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3175: RAISE OKL_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:
3178: l_return_status := Validate_Record(l_tqlv_rec);
3179: -- If any errors happen abort API

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

3176: END IF;
3177:
3178: l_return_status := Validate_Record(l_tqlv_rec);
3179: -- If any errors happen abort API
3180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE OKL_API.G_EXCEPTION_ERROR;
3184: END IF;

Line 3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3177:
3178: l_return_status := Validate_Record(l_tqlv_rec);
3179: -- If any errors happen abort API
3180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE OKL_API.G_EXCEPTION_ERROR;
3184: END IF;
3185:

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

3178: l_return_status := Validate_Record(l_tqlv_rec);
3179: -- If any errors happen abort API
3180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE OKL_API.G_EXCEPTION_ERROR;
3184: END IF;
3185:
3186: j:=j+1;

Line 3183: RAISE OKL_API.G_EXCEPTION_ERROR;

3179: -- If any errors happen abort API
3180: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3182: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE OKL_API.G_EXCEPTION_ERROR;
3184: END IF;
3185:
3186: j:=j+1;
3187: in_id(j) := l_tqlv_rec.id;

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

3260: p_amount => in_amount(j),
3261: p_currency_code => in_currency_code(j),
3262: x_rounded_amount => l_rounded_amount);
3263:
3264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3267: RAISE OKL_API.G_EXCEPTION_ERROR;
3268: END IF;

Line 3265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3261: p_currency_code => in_currency_code(j),
3262: x_rounded_amount => l_rounded_amount);
3263:
3264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3267: RAISE OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: in_amount(j) := l_rounded_amount;

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

3262: x_rounded_amount => l_rounded_amount);
3263:
3264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3267: RAISE OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: in_amount(j) := l_rounded_amount;
3270:

Line 3267: RAISE OKL_API.G_EXCEPTION_ERROR;

3263:
3264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3267: RAISE OKL_API.G_EXCEPTION_ERROR;
3268: END IF;
3269: in_amount(j) := l_rounded_amount;
3270:
3271: i := p_tqlv_tbl.next(i);

Line 3428: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3424: in_last_update_date(i),
3425: in_last_update_login(i));
3426: END LOOP; -- Bug# 8429670 added
3427: x_tqlv_tbl := p_tqlv_tbl;
3428: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3429: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3430:
3431: EXCEPTION
3432: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

3425: in_last_update_login(i));
3426: END LOOP; -- Bug# 8429670 added
3427: x_tqlv_tbl := p_tqlv_tbl;
3428: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3429: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3430:
3431: EXCEPTION
3432: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3433: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 3432: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3428: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3429: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3430:
3431: EXCEPTION
3432: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3433: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3434: (
3435: l_api_name,
3436: G_PKG_NAME,

Line 3433: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3429: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3430:
3431: EXCEPTION
3432: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3433: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3434: (
3435: l_api_name,
3436: G_PKG_NAME,
3437: 'OKL_API.G_RET_STS_ERROR',

Line 3437: 'OKL_API.G_RET_STS_ERROR',

3433: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3434: (
3435: l_api_name,
3436: G_PKG_NAME,
3437: 'OKL_API.G_RET_STS_ERROR',
3438: x_msg_count,
3439: x_msg_data,
3440: '_PVT'
3441: );

Line 3442: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3438: x_msg_count,
3439: x_msg_data,
3440: '_PVT'
3441: );
3442: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3443: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3444: (
3445: l_api_name,
3446: G_PKG_NAME,

Line 3443: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

3439: x_msg_data,
3440: '_PVT'
3441: );
3442: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3443: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3444: (
3445: l_api_name,
3446: G_PKG_NAME,
3447: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3447: 'OKL_API.G_RET_STS_UNEXP_ERROR',

3443: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3444: (
3445: l_api_name,
3446: G_PKG_NAME,
3447: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3448: x_msg_count,
3449: x_msg_data,
3450: '_PVT'
3451: );

Line 3453: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

3449: x_msg_data,
3450: '_PVT'
3451: );
3452: WHEN OTHERS THEN
3453: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
3454: (
3455: l_api_name,
3456: G_PKG_NAME,
3457: 'OTHERS',

Line 3770: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

3766: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3767: i NUMBER := 0;
3768: -- Begin Post-Generation Change
3769: -- overall error status
3770: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3771: -- End Post-Generation Change
3772: BEGIN
3773: OKC_API.init_msg_list(p_init_msg_list);
3774: -- Make sure PL/SQL table has records in it before passing

Line 3787: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3783: x_msg_data => x_msg_data,
3784: p_tqlv_rec => p_tqlv_tbl(i));
3785: -- Begin Post-Generation Change
3786: -- store the highest degree of error
3787: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3788: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
3789: l_overall_status := x_return_status;
3790: END IF;
3791: END IF;

Line 3788: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

3784: p_tqlv_rec => p_tqlv_tbl(i));
3785: -- Begin Post-Generation Change
3786: -- store the highest degree of error
3787: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3788: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
3789: l_overall_status := x_return_status;
3790: END IF;
3791: END IF;
3792: -- End Post-Generation Change

Line 4776: IF (x_tqlv_rec.due_date = OKL_API.G_MISS_DATE)

4772: END IF;
4773: -- BAKUCHIB 2667636 End
4774: -- PAGARG Bug 4161133 start
4775: -- Populate new column due_date
4776: IF (x_tqlv_rec.due_date = OKL_API.G_MISS_DATE)
4777: THEN
4778: x_tqlv_rec.due_date := l_tqlv_rec.due_date;
4779: END IF;
4780: -- PAGARG Bug 4161133 end

Line 4782: IF (x_tqlv_rec.try_id = OKL_API.G_MISS_NUM)

4778: x_tqlv_rec.due_date := l_tqlv_rec.due_date;
4779: END IF;
4780: -- PAGARG Bug 4161133 end
4781: -- rmunjulu Sales_Tax_Enhancement
4782: IF (x_tqlv_rec.try_id = OKL_API.G_MISS_NUM)
4783: THEN
4784: x_tqlv_rec.try_id := l_tqlv_rec.try_id;
4785: END IF;
4786: RETURN(l_return_status);

Line 4963: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

4959: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4960: i NUMBER := 0;
4961: -- Begin Post-Generation Change
4962: -- overall error status
4963: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4964: -- End Post-Generation Change
4965: BEGIN
4966: OKC_API.init_msg_list(p_init_msg_list);
4967: -- Make sure PL/SQL table has records in it before passing

Line 4981: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

4977: p_tqlv_rec => p_tqlv_tbl(i),
4978: x_tqlv_rec => x_tqlv_tbl(i));
4979: -- Begin Post-Generation Change
4980: -- store the highest degree of error
4981: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4982: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
4983: l_overall_status := x_return_status;
4984: END IF;
4985: END IF;

Line 4982: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

4978: x_tqlv_rec => x_tqlv_tbl(i));
4979: -- Begin Post-Generation Change
4980: -- store the highest degree of error
4981: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4982: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
4983: l_overall_status := x_return_status;
4984: END IF;
4985: END IF;
4986: -- End Post-Generation Change

Line 5288: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5284: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5285: i NUMBER := 0;
5286: -- Begin Post-Generation Change
5287: -- overall error status
5288: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5289: -- End Post-Generation Change
5290: BEGIN
5291: OKC_API.init_msg_list(p_init_msg_list);
5292: -- Make sure PL/SQL table has records in it before passing

Line 5305: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

5301: x_msg_data => x_msg_data,
5302: p_tqlv_rec => p_tqlv_tbl(i));
5303: -- Begin Post-Generation Change
5304: -- store the highest degree of error
5305: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5306: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5307: l_overall_status := x_return_status;
5308: END IF;
5309: END IF;

Line 5306: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

5302: p_tqlv_rec => p_tqlv_tbl(i));
5303: -- Begin Post-Generation Change
5304: -- store the highest degree of error
5305: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5306: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5307: l_overall_status := x_return_status;
5308: END IF;
5309: END IF;
5310: -- End Post-Generation Change