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.OKC_QA_PRICE_PVT dependencies on OKC_DEBUG

Line 61: okc_debug.Set_Indentation('Check_Price');

57:
58:
59: Begin
60: IF (l_debug = 'Y') THEN
61: okc_debug.Set_Indentation('Check_Price');
62: okc_debug.Log('1000: Entering Check_Price',2);
63: END IF;
64: --
65: x_return_status := okc_api.g_ret_sts_success;

Line 62: okc_debug.Log('1000: Entering Check_Price',2);

58:
59: Begin
60: IF (l_debug = 'Y') THEN
61: okc_debug.Set_Indentation('Check_Price');
62: okc_debug.Log('1000: Entering Check_Price',2);
63: END IF;
64: --
65: x_return_status := okc_api.g_ret_sts_success;
66: If Nvl(fnd_profile.value('OKC_ADVANCED_PRICING'), 'N') <> 'Y' Then

Line 68: okc_debug.log('1010: Profile OKC_ADVANCED_PRICING - ' || fnd_profile.value('OKC_ADVANCED_PRICING'));

64: --
65: x_return_status := okc_api.g_ret_sts_success;
66: If Nvl(fnd_profile.value('OKC_ADVANCED_PRICING'), 'N') <> 'Y' Then
67: IF (l_debug = 'Y') THEN
68: okc_debug.log('1010: Profile OKC_ADVANCED_PRICING - ' || fnd_profile.value('OKC_ADVANCED_PRICING'));
69: END IF;
70: -- No need to set the return status here otherwise a blank message
71: -- will show up in the QA window with error/warning status
72: Raise G_EXCEPTION_HALT_VALIDATION;

Line 76: okc_debug.log('1020: Before opening cursor k_csr');

72: Raise G_EXCEPTION_HALT_VALIDATION;
73: End If;
74: --
75: IF (l_debug = 'Y') THEN
76: okc_debug.log('1020: Before opening cursor k_csr');
77: END IF;
78: Open k_csr;
79: Fetch k_csr
80: Into l_application_id,

Line 86: okc_debug.log('1030: After closing cursor k_csr');

82: l_buy_or_sell,
83: l_orig_system_source_code;
84: Close k_csr;
85: IF (l_debug = 'Y') THEN
86: okc_debug.log('1030: After closing cursor k_csr');
87: END IF;
88: --
89: -- Price check is to be done only for OKC and OKO Contracts
90: IF (l_debug = 'Y') THEN

Line 91: okc_debug.log('1040: Application_id - ' || To_Char(l_application_id));

87: END IF;
88: --
89: -- Price check is to be done only for OKC and OKO Contracts
90: IF (l_debug = 'Y') THEN
91: okc_debug.log('1040: Application_id - ' || To_Char(l_application_id));
92: END IF;
93: If l_application_id Not in (510, 871) Then
94: -- No need to set the return status here
95: Raise G_EXCEPTION_HALT_VALIDATION;

Line 101: okc_debug.log('1040: Intent - ' ||l_buy_or_sell);

97:
98: -- NO Price check for buy contracts - Advanced pricing is not used
99: If l_buy_or_sell='B' Then
100: IF (l_debug = 'Y') THEN
101: okc_debug.log('1040: Intent - ' ||l_buy_or_sell);
102: END IF;
103: Raise G_EXCEPTION_HALT_VALIDATION;
104: End If;
105: --

Line 109: okc_debug.log('1040: Intent - ' ||l_orig_system_source_code);

105: --
106: -- NO Price check for Contracts created from quote/istore, always accept price from quote
107: If l_orig_system_source_code = 'ASO_HDR' Then
108: IF (l_debug = 'Y') THEN
109: okc_debug.log('1040: Intent - ' ||l_orig_system_source_code);
110: END IF;
111:
112: OKC_API.set_message(
113: p_app_name => G_APP_NAME,

Line 144: okc_debug.log('1050: Before calling okc_price_pub');

140: ELSE
141: --execute price_qa_check as earlier .
142: --
143: IF (l_debug = 'Y') THEN
144: okc_debug.log('1050: Before calling okc_price_pub');
145: END IF;
146: OKC_Price_Pub.Update_Contract_Price(
147: p_api_version => 1.0,
148: p_init_msg_list => OKC_API.G_FALSE,

Line 160: okc_debug.log('1060: After calling okc_price_pub');

156: x_msg_data => l_msg_data);
157: END IF; ---IF l_price_qa_check_yn = 'N' THEN
158: --
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('1060: After calling okc_price_pub');
161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);
162: END IF;
163: If (l_return_status <> 'S') Then
164: -- In case of Unexpected error, return error so that it can be shown

Line 161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);

157: END IF; ---IF l_price_qa_check_yn = 'N' THEN
158: --
159: IF (l_debug = 'Y') THEN
160: okc_debug.log('1060: After calling okc_price_pub');
161: okc_debug.log('1070: Return status from okc_price_pub - ' || l_return_status);
162: END IF;
163: If (l_return_status <> 'S') Then
164: -- In case of Unexpected error, return error so that it can be shown
165: -- as an Error in QA window. For normal error, return Success.

Line 184: okc_debug.log('1080: Price stored at the header level - ' || To_Char(l_estimated_price));

180: End If;
181: --
182: If nvl(l_chr_net_price, 0) <> nvl(l_estimated_price, 0) Then
183: IF (l_debug = 'Y') THEN
184: okc_debug.log('1080: Price stored at the header level - ' || To_Char(l_estimated_price));
185: END IF;
186: IF (l_debug = 'Y') THEN
187: okc_debug.log('1090: Price returned from okc_price_pub - ' || To_Char(l_chr_net_price));
188: END IF;

Line 187: okc_debug.log('1090: Price returned from okc_price_pub - ' || To_Char(l_chr_net_price));

183: IF (l_debug = 'Y') THEN
184: okc_debug.log('1080: Price stored at the header level - ' || To_Char(l_estimated_price));
185: END IF;
186: IF (l_debug = 'Y') THEN
187: okc_debug.log('1090: Price returned from okc_price_pub - ' || To_Char(l_chr_net_price));
188: END IF;
189: OKC_API.set_message(
190: p_app_name => G_APP_NAME,
191: p_msg_name => 'OKC_QA_INVALID_PRICE');

Line 201: okc_debug.Log('1100: Exiting Check_Price', 2);

197: p_app_name => G_APP_NAME,
198: p_msg_name => G_QA_SUCCESS);
199: --
200: IF (l_debug = 'Y') THEN
201: okc_debug.Log('1100: Exiting Check_Price', 2);
202: okc_debug.Reset_Indentation;
203: END IF;
204: --
205: Exception

Line 202: okc_debug.Reset_Indentation;

198: p_msg_name => G_QA_SUCCESS);
199: --
200: IF (l_debug = 'Y') THEN
201: okc_debug.Log('1100: Exiting Check_Price', 2);
202: okc_debug.Reset_Indentation;
203: END IF;
204: --
205: Exception
206: When G_EXCEPTION_HALT_VALIDATION Then

Line 208: okc_debug.Log('1110: Exiting Check_Price', 2);

204: --
205: Exception
206: When G_EXCEPTION_HALT_VALIDATION Then
207: IF (l_debug = 'Y') THEN
208: okc_debug.Log('1110: Exiting Check_Price', 2);
209: okc_debug.Reset_Indentation;
210: END IF;
211: When Others Then
212: IF (l_debug = 'Y') THEN

Line 209: okc_debug.Reset_Indentation;

205: Exception
206: When G_EXCEPTION_HALT_VALIDATION Then
207: IF (l_debug = 'Y') THEN
208: okc_debug.Log('1110: Exiting Check_Price', 2);
209: okc_debug.Reset_Indentation;
210: END IF;
211: When Others Then
212: IF (l_debug = 'Y') THEN
213: okc_debug.Log('1120: Exiting Check_Price', 2);

Line 213: okc_debug.Log('1120: Exiting Check_Price', 2);

209: okc_debug.Reset_Indentation;
210: END IF;
211: When Others Then
212: IF (l_debug = 'Y') THEN
213: okc_debug.Log('1120: Exiting Check_Price', 2);
214: okc_debug.Reset_Indentation;
215: END IF;
216: -- store SQL error message on message stack
217: OKC_API.SET_MESSAGE(

Line 214: okc_debug.Reset_Indentation;

210: END IF;
211: When Others Then
212: IF (l_debug = 'Y') THEN
213: okc_debug.Log('1120: Exiting Check_Price', 2);
214: okc_debug.Reset_Indentation;
215: END IF;
216: -- store SQL error message on message stack
217: OKC_API.SET_MESSAGE(
218: p_app_name => G_APP_NAME,

Line 332: okc_debug.Set_Indentation('validate_covered_line_qty');

328:
329: BEGIN
330: x_return_status := okc_api.g_ret_sts_success;
331: IF (l_debug = 'Y') THEN
332: okc_debug.Set_Indentation('validate_covered_line_qty');
333: END IF;
334:
335: IF (l_debug = 'Y') THEN
336: okc_debug.Log('Start : okc_price_pvt.validate_covered_line_qty ',3);

Line 336: okc_debug.Log('Start : okc_price_pvt.validate_covered_line_qty ',3);

332: okc_debug.Set_Indentation('validate_covered_line_qty');
333: END IF;
334:
335: IF (l_debug = 'Y') THEN
336: okc_debug.Log('Start : okc_price_pvt.validate_covered_line_qty ',3);
337: END IF;
338: /* Note: we already perform validation to ensure that the contract is for intent of sale and for OKC, OKO
339: in OKC_QA_PRICE_PVT.Check_Price */
340:

Line 344: okc_debug.Log('Get quantity of line with id: ' || p_cle_id, 5);

340:
341:
342: /* Get quantity of (sub) line of linestyle 'covered line' */
343: IF (l_debug = 'Y') THEN
344: okc_debug.Log('Get quantity of line with id: ' || p_cle_id, 5);
345: okc_debug.Log('Get quantity of line p_cle_id = ' || p_cle_id || 'with jtot_object=''OKX_COVLINE'' and lse_id=41',5);
346: END IF;
347: IF c_get_quantity1%ISOPEN THEN
348: CLOSE c_get_quantity1;

Line 345: okc_debug.Log('Get quantity of line p_cle_id = ' || p_cle_id || 'with jtot_object=''OKX_COVLINE'' and lse_id=41',5);

341:
342: /* Get quantity of (sub) line of linestyle 'covered line' */
343: IF (l_debug = 'Y') THEN
344: okc_debug.Log('Get quantity of line with id: ' || p_cle_id, 5);
345: okc_debug.Log('Get quantity of line p_cle_id = ' || p_cle_id || 'with jtot_object=''OKX_COVLINE'' and lse_id=41',5);
346: END IF;
347: IF c_get_quantity1%ISOPEN THEN
348: CLOSE c_get_quantity1;
349: END IF;

Line 354: okc_debug.Log('l_qty1: ' || l_qty1, 5);

350: OPEN c_get_quantity1 (b_cle_id => p_cle_id);
351: FETCH c_get_quantity1 INTO l_parent_cle_id, l_qty1;
352: CLOSE c_get_quantity1;
353: IF (l_debug = 'Y') THEN
354: okc_debug.Log('l_qty1: ' || l_qty1, 5);
355: END IF;
356:
357:
358: /* Get quantity of parent (top) line being pointed to */

Line 360: okc_debug.Log('Get quantity of parent (top) line being pointed to: '||l_parent_cle_id, 5);

356:
357:
358: /* Get quantity of parent (top) line being pointed to */
359: IF (l_debug = 'Y') THEN
360: okc_debug.Log('Get quantity of parent (top) line being pointed to: '||l_parent_cle_id, 5);
361: END IF;
362: IF c_get_quantity2%ISOPEN THEN
363: CLOSE c_get_quantity2;
364: END IF;

Line 369: okc_debug.Log('l_qty2: ' || l_qty2, 5);

365: OPEN c_get_quantity2 (b_cle_id => l_parent_cle_id);
366: FETCH c_get_quantity2 INTO l_qty2;
367: CLOSE c_get_quantity2;
368: IF (l_debug = 'Y') THEN
369: okc_debug.Log('l_qty2: ' || l_qty2, 5);
370: END IF;
371:
372:
373: IF l_qty1 <> OKC_API.G_MISS_NUM AND l_qty2 <> OKC_API.G_MISS_NUM

Line 377: okc_debug.Log('l_qty1 and l_qty2 are not the same so setting error message on stack...',5);

373: IF l_qty1 <> OKC_API.G_MISS_NUM AND l_qty2 <> OKC_API.G_MISS_NUM
374: AND l_qty1 <> l_qty2
375: THEN
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('l_qty1 and l_qty2 are not the same so setting error message on stack...',5);
378: END IF;
379:
380: /* get the line number of the immediate (top) line */
381: i:= p_l_id_tbl.first;

Line 428: okc_debug.Log('Covered line number ' || l_line_number || 'and id: ' || p_cle_id || 'serviceable product have a quantity mismatch.',5);

424: p_token1_value => l_line_number,
425: p_token2 => 'LNUMB2',
426: p_token2_value => l_parent_line_number);
427: IF (l_debug = 'Y') THEN
428: okc_debug.Log('Covered line number ' || l_line_number || 'and id: ' || p_cle_id || 'serviceable product have a quantity mismatch.',5);
429: okc_debug.Log('l_qty1: ' || l_qty1,5);
430: okc_debug.Log('l_qty2: ' || l_qty2,5);
431: END IF;
432: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 429: okc_debug.Log('l_qty1: ' || l_qty1,5);

425: p_token2 => 'LNUMB2',
426: p_token2_value => l_parent_line_number);
427: IF (l_debug = 'Y') THEN
428: okc_debug.Log('Covered line number ' || l_line_number || 'and id: ' || p_cle_id || 'serviceable product have a quantity mismatch.',5);
429: okc_debug.Log('l_qty1: ' || l_qty1,5);
430: okc_debug.Log('l_qty2: ' || l_qty2,5);
431: END IF;
432: x_return_status := OKC_API.G_RET_STS_ERROR;
433:

Line 430: okc_debug.Log('l_qty2: ' || l_qty2,5);

426: p_token2_value => l_parent_line_number);
427: IF (l_debug = 'Y') THEN
428: okc_debug.Log('Covered line number ' || l_line_number || 'and id: ' || p_cle_id || 'serviceable product have a quantity mismatch.',5);
429: okc_debug.Log('l_qty1: ' || l_qty1,5);
430: okc_debug.Log('l_qty2: ' || l_qty2,5);
431: END IF;
432: x_return_status := OKC_API.G_RET_STS_ERROR;
433:
434: END IF;

Line 439: okc_debug.Log('passed okc_price_pvt.validate_covered_line_qty');

435:
436:
437: If x_return_status <> OKC_API.G_RET_STS_ERROR then
438: IF (l_debug = 'Y') THEN
439: okc_debug.Log('passed okc_price_pvt.validate_covered_line_qty');
440: END IF;
441: End if;
442:
443: IF (l_debug = 'Y') THEN

Line 444: okc_debug.Log('End : okc_price_pvt.validate_covered_line_qty ',3);

440: END IF;
441: End if;
442:
443: IF (l_debug = 'Y') THEN
444: okc_debug.Log('End : okc_price_pvt.validate_covered_line_qty ',3);
445: END IF;
446:
447: EXCEPTION
448: WHEN OTHERS THEN

Line 450: okc_debug.Log('Error : unexpected error in okc_price_pvt.validate_covered_line_qty ',3);

446:
447: EXCEPTION
448: WHEN OTHERS THEN
449: IF (l_debug = 'Y') THEN
450: okc_debug.Log('Error : unexpected error in okc_price_pvt.validate_covered_line_qty ',3);
451: okc_debug.Log('Error : '|| sqlerrm, 3);
452: END IF;
453:
454: IF c_get_quantity1%ISOPEN THEN

Line 451: okc_debug.Log('Error : '|| sqlerrm, 3);

447: EXCEPTION
448: WHEN OTHERS THEN
449: IF (l_debug = 'Y') THEN
450: okc_debug.Log('Error : unexpected error in okc_price_pvt.validate_covered_line_qty ',3);
451: okc_debug.Log('Error : '|| sqlerrm, 3);
452: END IF;
453:
454: IF c_get_quantity1%ISOPEN THEN
455: CLOSE c_get_quantity1;

Line 473: okc_debug.Set_Indentation('check_covered_line_qty');

469:
470:
471: BEGIN
472: IF (l_debug = 'Y') THEN
473: okc_debug.Set_Indentation('check_covered_line_qty');
474: okc_debug.Log('1000: Entering check_covered_line_qty',2);
475: END IF;
476: --
477: x_return_status := okc_api.g_ret_sts_success;

Line 474: okc_debug.Log('1000: Entering check_covered_line_qty',2);

470:
471: BEGIN
472: IF (l_debug = 'Y') THEN
473: okc_debug.Set_Indentation('check_covered_line_qty');
474: okc_debug.Log('1000: Entering check_covered_line_qty',2);
475: END IF;
476: --
477: x_return_status := okc_api.g_ret_sts_success;
478:

Line 490: okc_debug.log('1010: Profile OKC_ADVANCED_PRICING - ' || fnd_profile.value('OKC_ADVANCED_PRICING'));

486: If advanced pricing is off, we need to run this QA check to raise a QA error
487: in case the covered line quantity and non service quantity don't match.
488:
489: IF (l_debug = 'Y') THEN
490: okc_debug.log('1010: Profile OKC_ADVANCED_PRICING - ' || fnd_profile.value('OKC_ADVANCED_PRICING'));
491: END IF;
492: -- No need to set the return status here otherwise a blank message
493: -- will show up in the QA window with error/warning status
494: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 499: okc_debug.log('1020: Before opening cursor k_csr');

495: END IF;
496: *****************************************************************/
497: --
498: IF (l_debug = 'Y') THEN
499: okc_debug.log('1020: Before opening cursor k_csr');
500: END IF;
501: OPEN k_csr;
502: FETCH k_csr
503: INTO l_application_id,

Line 508: okc_debug.log('1030: After closing cursor k_csr');

504: l_buy_or_sell,
505: l_orig_system_source_code;
506: CLOSE k_csr;
507: IF (l_debug = 'Y') THEN
508: okc_debug.log('1030: After closing cursor k_csr');
509: END IF;
510:
511: --
512: /* covered line/non-service qty's check is to be done only for OKC

Line 515: okc_debug.log('1040: Application_id - ' || To_Char(l_application_id));

511: --
512: /* covered line/non-service qty's check is to be done only for OKC
513: and OKO Contracts */
514: IF (l_debug = 'Y') THEN
515: okc_debug.log('1040: Application_id - ' || To_Char(l_application_id));
516: END IF;
517: If l_application_id Not in (510, 871) Then
518: -- No need to set the return status here
519: Raise G_EXCEPTION_HALT_VALIDATION;

Line 525: okc_debug.log('1045: Intent - ' ||l_buy_or_sell);

521:
522: -- perform only for sell contracts
523: IF l_buy_or_sell='B' THEN
524: IF (l_debug = 'Y') THEN
525: okc_debug.log('1045: Intent - ' ||l_buy_or_sell);
526: END IF;
527: RAISE G_EXCEPTION_HALT_VALIDATION;
528: END IF;
529: --

Line 534: okc_debug.log('1050: Intent - ' ||l_orig_system_source_code);

530:
531: -- NO Price check for Contracts created from quote/istore, always accept price from quote
532: If l_orig_system_source_code = 'ASO_HDR' Then
533: IF (l_debug = 'Y') THEN
534: okc_debug.log('1050: Intent - ' ||l_orig_system_source_code);
535: END IF;
536:
537: OKC_API.set_message(
538: p_app_name => G_APP_NAME,

Line 570: okc_debug.log('1055: Before looping thorough all lines/subines for contract');

566: ELSE
567: --execute new_qa_check as earlier .
568: --
569: IF (l_debug = 'Y') THEN
570: okc_debug.log('1055: Before looping thorough all lines/subines for contract');
571: END IF;
572:
573: SELECT cle_id, id, line_number, lse_id
574: BULK COLLECT INTO l_cle_id_tbl,l_id_tbl, l_line_number_tbl, l_lse_id_tbl

Line 579: okc_debug.Log('1060 : select rowcount'||SQL%ROWCOUNT, 1);

575: FROM okc_k_lines_b
576: CONNECT BY PRIOR id = cle_id
577: START WITH chr_id = p_chr_id;
578: IF (l_debug = 'Y') THEN
579: okc_debug.Log('1060 : select rowcount'||SQL%ROWCOUNT, 1);
580: END IF;
581:
582: i:= l_id_tbl.first;
583: IF (l_debug = 'Y') THEN

Line 584: okc_debug.Log('1065 :starting out nocopy loop to check non-service/covered line quantities', 1);

580: END IF;
581:
582: i:= l_id_tbl.first;
583: IF (l_debug = 'Y') THEN
584: okc_debug.Log('1065 :starting out nocopy loop to check non-service/covered line quantities', 1);
585: END IF;
586: WHILE i is not null LOOP
587: IF l_lse_id_tbl(i) = 41 THEN
588: /** perform validation to ensure that the quantity of a (sub) line of linestyle 'covered line'

Line 592: okc_debug.Log('1070 : before calling validate_covered_line_qty ', 3);

588: /** perform validation to ensure that the quantity of a (sub) line of linestyle 'covered line'
589: matches that of the (top) line to which it points. **/
590:
591: IF (l_debug = 'Y') THEN
592: okc_debug.Log('1070 : before calling validate_covered_line_qty ', 3);
593: okc_debug.Log('1075 : p_chr_id: ' || to_char(p_chr_id), 3);
594: okc_debug.Log('1080 : p_cle_id: ' || to_char(l_id_tbl(i)), 3);
595: END IF;
596: validate_covered_line_qty (p_chr_id => p_CHR_ID,

Line 593: okc_debug.Log('1075 : p_chr_id: ' || to_char(p_chr_id), 3);

589: matches that of the (top) line to which it points. **/
590:
591: IF (l_debug = 'Y') THEN
592: okc_debug.Log('1070 : before calling validate_covered_line_qty ', 3);
593: okc_debug.Log('1075 : p_chr_id: ' || to_char(p_chr_id), 3);
594: okc_debug.Log('1080 : p_cle_id: ' || to_char(l_id_tbl(i)), 3);
595: END IF;
596: validate_covered_line_qty (p_chr_id => p_CHR_ID,
597: p_cle_id => l_id_tbl(i),

Line 594: okc_debug.Log('1080 : p_cle_id: ' || to_char(l_id_tbl(i)), 3);

590:
591: IF (l_debug = 'Y') THEN
592: okc_debug.Log('1070 : before calling validate_covered_line_qty ', 3);
593: okc_debug.Log('1075 : p_chr_id: ' || to_char(p_chr_id), 3);
594: okc_debug.Log('1080 : p_cle_id: ' || to_char(l_id_tbl(i)), 3);
595: END IF;
596: validate_covered_line_qty (p_chr_id => p_CHR_ID,
597: p_cle_id => l_id_tbl(i),
598: p_l_id_tbl => l_id_tbl,

Line 604: okc_debug.Log('1085 : after calling validate_covered_line_qty ' || 'l_return_status: ' || l_return_status, 3);

600: p_l_line_number_tbl => l_line_number_tbl,
601: x_return_status => l_return_status
602: );
603: IF (l_debug = 'Y') THEN
604: okc_debug.Log('1085 : after calling validate_covered_line_qty ' || 'l_return_status: ' || l_return_status, 3);
605: END IF;
606:
607: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
608: --we want QA to pick up all the error messages on the stack

Line 623: okc_debug.Log('1090 : after loop to check non-service/covered line quantities', 1);

619:
620: END IF; ---IF l_new_qa_check_yn = 'N' THEN
621: --
622: IF (l_debug = 'Y') THEN
623: okc_debug.Log('1090 : after loop to check non-service/covered line quantities', 1);
624: END IF;
625:
626: IF l_qa_covered_line_qty_mismatch = TRUE THEN
627: /* this means that validate_covered_line_qty() has put some error

Line 632: okc_debug.Log('1095 : l_qa_covered_line_qty_mismatch: TRUE', 1);

628: messages on the error stack which we now want QA to display in the
629: QA results */
630: l_return_status := OKC_API.G_RET_STS_ERROR;
631: IF (l_debug = 'Y') THEN
632: okc_debug.Log('1095 : l_qa_covered_line_qty_mismatch: TRUE', 1);
633: END IF;
634: ELSE
635: IF (l_debug = 'Y') THEN
636: okc_debug.Log('1100 : l_qa_covered_line_qty_mismatch: FALSE', 1);

Line 636: okc_debug.Log('1100 : l_qa_covered_line_qty_mismatch: FALSE', 1);

632: okc_debug.Log('1095 : l_qa_covered_line_qty_mismatch: TRUE', 1);
633: END IF;
634: ELSE
635: IF (l_debug = 'Y') THEN
636: okc_debug.Log('1100 : l_qa_covered_line_qty_mismatch: FALSE', 1);
637: END IF;
638: END IF;
639:
640:

Line 653: okc_debug.Log('1105: Exiting check_covered_line_qty', 2);

649: p_app_name => G_APP_NAME,
650: p_msg_name => G_QA_SUCCESS);
651: --
652: IF (l_debug = 'Y') THEN
653: okc_debug.Log('1105: Exiting check_covered_line_qty', 2);
654: okc_debug.Reset_Indentation;
655: END IF;
656: --
657: EXCEPTION

Line 654: okc_debug.Reset_Indentation;

650: p_msg_name => G_QA_SUCCESS);
651: --
652: IF (l_debug = 'Y') THEN
653: okc_debug.Log('1105: Exiting check_covered_line_qty', 2);
654: okc_debug.Reset_Indentation;
655: END IF;
656: --
657: EXCEPTION
658: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 660: okc_debug.Log('1110: Exiting check_covered_line_qty', 2);

656: --
657: EXCEPTION
658: WHEN G_EXCEPTION_HALT_VALIDATION THEN
659: IF (l_debug = 'Y') THEN
660: okc_debug.Log('1110: Exiting check_covered_line_qty', 2);
661: okc_debug.Reset_Indentation;
662: END IF;
663: WHEN Others THEN
664: IF (l_debug = 'Y') THEN

Line 661: okc_debug.Reset_Indentation;

657: EXCEPTION
658: WHEN G_EXCEPTION_HALT_VALIDATION THEN
659: IF (l_debug = 'Y') THEN
660: okc_debug.Log('1110: Exiting check_covered_line_qty', 2);
661: okc_debug.Reset_Indentation;
662: END IF;
663: WHEN Others THEN
664: IF (l_debug = 'Y') THEN
665: okc_debug.Log('1120: Exiting check_covered_line_qty', 2);

Line 665: okc_debug.Log('1120: Exiting check_covered_line_qty', 2);

661: okc_debug.Reset_Indentation;
662: END IF;
663: WHEN Others THEN
664: IF (l_debug = 'Y') THEN
665: okc_debug.Log('1120: Exiting check_covered_line_qty', 2);
666: okc_debug.Reset_Indentation;
667: END IF;
668: -- store SQL error message on message stack
669: OKC_API.SET_MESSAGE(

Line 666: okc_debug.Reset_Indentation;

662: END IF;
663: WHEN Others THEN
664: IF (l_debug = 'Y') THEN
665: okc_debug.Log('1120: Exiting check_covered_line_qty', 2);
666: okc_debug.Reset_Indentation;
667: END IF;
668: -- store SQL error message on message stack
669: OKC_API.SET_MESSAGE(
670: p_app_name => G_APP_NAME,