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: -- Arrays to store pl-sql table and pass it to bulk insert
2999: in_id NumberTabTyp;

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: -- Arrays to store pl-sql table and pass it to bulk insert
2999: in_id NumberTabTyp;
3000: in_sty_id NumberTabTyp;

Line 3084: OKL_API.init_msg_list(p_init_msg_list);

3080: l_conc_reg_id NUMBER(15);
3081: l_lang VARCHAR2(12);
3082:
3083: BEGIN
3084: OKL_API.init_msg_list(p_init_msg_list);
3085: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3086: G_PKG_NAME,
3087: p_init_msg_list,
3088: l_api_version,

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

3081: l_lang VARCHAR2(12);
3082:
3083: BEGIN
3084: OKL_API.init_msg_list(p_init_msg_list);
3085: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
3086: G_PKG_NAME,
3087: p_init_msg_list,
3088: l_api_version,
3089: p_api_version,

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

3088: l_api_version,
3089: p_api_version,
3090: '_PVT',
3091: x_return_status);
3092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3095: RAISE OKL_API.G_EXCEPTION_ERROR;
3096: END IF;

Line 3093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3089: p_api_version,
3090: '_PVT',
3091: x_return_status);
3092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3095: RAISE OKL_API.G_EXCEPTION_ERROR;
3096: END IF;
3097:

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

3090: '_PVT',
3091: x_return_status);
3092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3095: RAISE OKL_API.G_EXCEPTION_ERROR;
3096: END IF;
3097:
3098: i := p_tqlv_tbl.FIRST;

Line 3095: RAISE OKL_API.G_EXCEPTION_ERROR;

3091: x_return_status);
3092: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3094: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3095: RAISE OKL_API.G_EXCEPTION_ERROR;
3096: END IF;
3097:
3098: i := p_tqlv_tbl.FIRST;
3099: j :=0;

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

3118: l_tqlv_rec.last_update_login := l_login_id;
3119:
3120: l_tqlv_rec.currency_conversion_code := l_curr_code;
3121: IF l_tqlv_rec.currency_code IS NULL
3122: OR l_tqlv_rec.currency_code = OKL_API.G_MISS_CHAR THEN
3123: l_tqlv_rec.currency_code := l_tqlv_rec.currency_conversion_code;
3124: END IF;
3125:
3126: IF l_tqlv_rec.defaulted_yn IS NULL

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

3123: l_tqlv_rec.currency_code := l_tqlv_rec.currency_conversion_code;
3124: END IF;
3125:
3126: IF l_tqlv_rec.defaulted_yn IS NULL
3127: OR l_tqlv_rec.defaulted_yn = OKL_API.G_MISS_CHAR THEN
3128: l_tqlv_rec.defaulted_yn := 'N';
3129: END IF;
3130:
3131: -- Default the ORG ID if a value is not passed

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

3129: END IF;
3130:
3131: -- Default the ORG ID if a value is not passed
3132: IF l_tqlv_rec.org_id IS NULL
3133: OR l_tqlv_rec.org_id = OKL_API.G_MISS_NUM THEN
3134: l_tqlv_rec.org_id := l_org_id;
3135: END IF;
3136:
3137: IF l_conc_req_id = -1

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

3162: l_tqlv_rec.sfwt_flag := 'N';
3163:
3164: l_return_status := Validate_Attributes(l_tqlv_rec);
3165: -- If any errors happen abort API
3166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3169: RAISE OKL_API.G_EXCEPTION_ERROR;
3170: END IF;

Line 3167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3163:
3164: l_return_status := Validate_Attributes(l_tqlv_rec);
3165: -- If any errors happen abort API
3166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3169: RAISE OKL_API.G_EXCEPTION_ERROR;
3170: END IF;
3171:

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

3164: l_return_status := Validate_Attributes(l_tqlv_rec);
3165: -- If any errors happen abort API
3166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3169: RAISE OKL_API.G_EXCEPTION_ERROR;
3170: END IF;
3171:
3172: l_return_status := Validate_Record(l_tqlv_rec);

Line 3169: RAISE OKL_API.G_EXCEPTION_ERROR;

3165: -- If any errors happen abort API
3166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3169: RAISE OKL_API.G_EXCEPTION_ERROR;
3170: END IF;
3171:
3172: l_return_status := Validate_Record(l_tqlv_rec);
3173: -- If any errors happen abort API

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

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

Line 3175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 3177: RAISE OKL_API.G_EXCEPTION_ERROR;

3173: -- If any errors happen abort API
3174: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3176: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3177: RAISE OKL_API.G_EXCEPTION_ERROR;
3178: END IF;
3179:
3180: j:=j+1;
3181: in_id(j) := l_tqlv_rec.id;

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

3254: p_amount => in_amount(j),
3255: p_currency_code => in_currency_code(j),
3256: x_rounded_amount => l_rounded_amount);
3257:
3258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3261: RAISE OKL_API.G_EXCEPTION_ERROR;
3262: END IF;

Line 3259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3255: p_currency_code => in_currency_code(j),
3256: x_rounded_amount => l_rounded_amount);
3257:
3258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3261: RAISE OKL_API.G_EXCEPTION_ERROR;
3262: END IF;
3263: in_amount(j) := l_rounded_amount;

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

3256: x_rounded_amount => l_rounded_amount);
3257:
3258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3261: RAISE OKL_API.G_EXCEPTION_ERROR;
3262: END IF;
3263: in_amount(j) := l_rounded_amount;
3264:

Line 3261: RAISE OKL_API.G_EXCEPTION_ERROR;

3257:
3258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3261: RAISE OKL_API.G_EXCEPTION_ERROR;
3262: END IF;
3263: in_amount(j) := l_rounded_amount;
3264:
3265: i := p_tqlv_tbl.next(i);

Line 3418: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3414: in_last_update_date(i),
3415: in_last_update_login(i));
3416:
3417: x_tqlv_tbl := p_tqlv_tbl;
3418: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3419: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3420:
3421: EXCEPTION
3422: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

3415: in_last_update_login(i));
3416:
3417: x_tqlv_tbl := p_tqlv_tbl;
3418: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3419: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3420:
3421: EXCEPTION
3422: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3423: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 3422: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3418: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3419: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3420:
3421: EXCEPTION
3422: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3424: (
3425: l_api_name,
3426: G_PKG_NAME,

Line 3423: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3419: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3420:
3421: EXCEPTION
3422: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3424: (
3425: l_api_name,
3426: G_PKG_NAME,
3427: 'OKL_API.G_RET_STS_ERROR',

Line 3427: 'OKL_API.G_RET_STS_ERROR',

3423: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3424: (
3425: l_api_name,
3426: G_PKG_NAME,
3427: 'OKL_API.G_RET_STS_ERROR',
3428: x_msg_count,
3429: x_msg_data,
3430: '_PVT'
3431: );

Line 3432: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3428: x_msg_count,
3429: x_msg_data,
3430: '_PVT'
3431: );
3432: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_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: x_msg_data,
3430: '_PVT'
3431: );
3432: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',

Line 3437: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 3443: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

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

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

3756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3757: i NUMBER := 0;
3758: -- Begin Post-Generation Change
3759: -- overall error status
3760: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3761: -- End Post-Generation Change
3762: BEGIN
3763: OKC_API.init_msg_list(p_init_msg_list);
3764: -- Make sure PL/SQL table has records in it before passing

Line 3777: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

3773: x_msg_data => x_msg_data,
3774: p_tqlv_rec => p_tqlv_tbl(i));
3775: -- Begin Post-Generation Change
3776: -- store the highest degree of error
3777: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3778: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
3779: l_overall_status := x_return_status;
3780: END IF;
3781: END IF;

Line 3778: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

3774: p_tqlv_rec => p_tqlv_tbl(i));
3775: -- Begin Post-Generation Change
3776: -- store the highest degree of error
3777: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3778: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
3779: l_overall_status := x_return_status;
3780: END IF;
3781: END IF;
3782: -- End Post-Generation Change

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

4762: END IF;
4763: -- BAKUCHIB 2667636 End
4764: -- PAGARG Bug 4161133 start
4765: -- Populate new column due_date
4766: IF (x_tqlv_rec.due_date = OKL_API.G_MISS_DATE)
4767: THEN
4768: x_tqlv_rec.due_date := l_tqlv_rec.due_date;
4769: END IF;
4770: -- PAGARG Bug 4161133 end

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

4768: x_tqlv_rec.due_date := l_tqlv_rec.due_date;
4769: END IF;
4770: -- PAGARG Bug 4161133 end
4771: -- rmunjulu Sales_Tax_Enhancement
4772: IF (x_tqlv_rec.try_id = OKL_API.G_MISS_NUM)
4773: THEN
4774: x_tqlv_rec.try_id := l_tqlv_rec.try_id;
4775: END IF;
4776: RETURN(l_return_status);

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

4949: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4950: i NUMBER := 0;
4951: -- Begin Post-Generation Change
4952: -- overall error status
4953: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4954: -- End Post-Generation Change
4955: BEGIN
4956: OKC_API.init_msg_list(p_init_msg_list);
4957: -- Make sure PL/SQL table has records in it before passing

Line 4971: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

4967: p_tqlv_rec => p_tqlv_tbl(i),
4968: x_tqlv_rec => x_tqlv_tbl(i));
4969: -- Begin Post-Generation Change
4970: -- store the highest degree of error
4971: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4972: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
4973: l_overall_status := x_return_status;
4974: END IF;
4975: END IF;

Line 4972: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

4968: x_tqlv_rec => x_tqlv_tbl(i));
4969: -- Begin Post-Generation Change
4970: -- store the highest degree of error
4971: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
4972: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
4973: l_overall_status := x_return_status;
4974: END IF;
4975: END IF;
4976: -- End Post-Generation Change

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

5274: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
5275: i NUMBER := 0;
5276: -- Begin Post-Generation Change
5277: -- overall error status
5278: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5279: -- End Post-Generation Change
5280: BEGIN
5281: OKC_API.init_msg_list(p_init_msg_list);
5282: -- Make sure PL/SQL table has records in it before passing

Line 5295: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

5291: x_msg_data => x_msg_data,
5292: p_tqlv_rec => p_tqlv_tbl(i));
5293: -- Begin Post-Generation Change
5294: -- store the highest degree of error
5295: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5296: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5297: l_overall_status := x_return_status;
5298: END IF;
5299: END IF;

Line 5296: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

5292: p_tqlv_rec => p_tqlv_tbl(i));
5293: -- Begin Post-Generation Change
5294: -- store the highest degree of error
5295: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5296: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5297: l_overall_status := x_return_status;
5298: END IF;
5299: END IF;
5300: -- End Post-Generation Change