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_LSS_PVT dependencies on OKC_DEBUG

Line 226: okc_debug.set_indentation('Validate_Date_RANGE');

222: lse_id=p_lssv_rec.lse_id and jtot_object_code<>p_lssv_rec.jtot_object_code;
223:
224: BEGIN
225: IF (l_debug = 'Y') THEN
226: okc_debug.set_indentation('Validate_Date_RANGE');
227: okc_debug.Log('100:entering Validate_Date_RANGE',1);
228: END IF;
229:
230: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 227: okc_debug.Log('100:entering Validate_Date_RANGE',1);

223:
224: BEGIN
225: IF (l_debug = 'Y') THEN
226: okc_debug.set_indentation('Validate_Date_RANGE');
227: okc_debug.Log('100:entering Validate_Date_RANGE',1);
228: END IF;
229:
230: x_return_status := OKC_API.G_RET_STS_SUCCESS;
231:

Line 234: okc_debug.Log('200:validate_date_range',1);

230: x_return_status := OKC_API.G_RET_STS_SUCCESS;
231:
232: If p_lssv_rec.end_date is null then
233: IF (l_debug = 'Y') THEN
234: okc_debug.Log('200:validate_date_range',1);
235: END IF;
236:
237: OPEN C1;
238: FETCH C1 into l_date;

Line 245: okc_debug.Log('300:validate_date_range',1);

241:
242: --- this is replaced by the if statement below
243: /* IF l_date = OKC_API.G_MISS_DATE then
244: IF (l_debug = 'Y') THEN
245: okc_debug.Log('300:validate_date_range',1);
246: END IF;
247: -- RAISE l_excp_error; -- This is where it should have been!!!!
248:
249: ELSE IF p_lssv_rec.start_date>=l_date then --this has been changed to check for the same date aswell

Line 253: okc_debug.Log('400:validate_date_range',1);

249: ELSE IF p_lssv_rec.start_date>=l_date then --this has been changed to check for the same date aswell
250: --for BUG #1932165
251: l_date:=p_lssv_rec.start_date;
252: IF (l_debug = 'Y') THEN
253: okc_debug.Log('400:validate_date_range',1);
254: END IF;
255: RAISE l_excp_error;
256: end if;
257:

Line 273: okc_debug.Log('500:8validate_date_range',1);

269: EXIT WHEN C2%NOTFOUND;
270: If trunc(p_lssv_rec.start_date)>=trunc(l_date) and trunc(p_lssv_rec.start_date)<=trunc(l_end_date) then
271: l_date:=p_lssv_rec.start_date;
272: IF (l_debug = 'Y') THEN
273: okc_debug.Log('500:8validate_date_range',1);
274: END IF;
275: RAISE l_excp_error;
276: Elsif trunc(nvl(p_lssv_rec.end_date,l_end_date+1))>=trunc(l_date)
277: and trunc(nvl(p_lssv_rec.end_date,l_end_date+1))<=trunc(l_end_date) then

Line 280: okc_debug.Log('500:validate_date_range',1);

276: Elsif trunc(nvl(p_lssv_rec.end_date,l_end_date+1))>=trunc(l_date)
277: and trunc(nvl(p_lssv_rec.end_date,l_end_date+1))<=trunc(l_end_date) then
278: l_date:=nvl(p_lssv_rec.end_date,l_end_date);
279: IF (l_debug = 'Y') THEN
280: okc_debug.Log('500:validate_date_range',1);
281: END IF;
282: RAISE l_excp_error;
283: ElsIf trunc(l_date)>=trunc(p_lssv_rec.start_date)
284: and trunc(l_date)<=trunc(nvl(p_lssv_rec.end_date,l_end_date+1)) then

Line 286: okc_debug.Log('600:validate_date_range',1);

282: RAISE l_excp_error;
283: ElsIf trunc(l_date)>=trunc(p_lssv_rec.start_date)
284: and trunc(l_date)<=trunc(nvl(p_lssv_rec.end_date,l_end_date+1)) then
285: IF (l_debug = 'Y') THEN
286: okc_debug.Log('600:validate_date_range',1);
287: END IF;
288: RAISE l_excp_error;
289: ElsIf trunc(l_end_date)>=trunc(p_lssv_rec.start_date)
290: and trunc(l_end_date)<=trunc(nvl(p_lssv_rec.end_date,l_end_date+1)) then

Line 293: okc_debug.Log('700:validate_date_range',1);

289: ElsIf trunc(l_end_date)>=trunc(p_lssv_rec.start_date)
290: and trunc(l_end_date)<=trunc(nvl(p_lssv_rec.end_date,l_end_date+1)) then
291: l_date:=l_end_date;
292: IF (l_debug = 'Y') THEN
293: okc_debug.Log('700:validate_date_range',1);
294: END IF;
295: RAISE l_excp_error;
296: END IF;
297: END LOOP;

Line 303: okc_debug.Log('800:validate_date_range',1);

299: return x_return_status;
300: EXCEPTION
301: WHEN l_excp_error then
302: IF (l_debug = 'Y') THEN
303: okc_debug.Log('800:validate_date_range',1);
304: END IF;
305: x_return_status:=OKC_API.G_RET_STS_ERROR;
306: IF C2%ISOPEN then
307: CLOSE C2;

Line 317: okc_debug.Log('800:validate_date_range',1);

313:
314: WHEN OTHERS THEN
315: -- store SQL error message on message stack for caller
316: IF (l_debug = 'Y') THEN
317: okc_debug.Log('800:validate_date_range',1);
318: END IF;
319: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
320: p_msg_name => g_unexpected_error,
321: p_token1 => g_sqlcode_token,

Line 334: okc_debug.reset_indentation;

330: CLOSE C2;
331: END IF;
332: return x_return_status;
333: IF (l_debug = 'Y') THEN
334: okc_debug.reset_indentation;
335: END IF;
336: END ValidAte_DATE_RANGE;
337:
338: --this is the old style range check. Was failing in case given start date and end date were the one

Line 752: okc_debug.set_indentation('Validate_Record');

748: l_dummy VARCHAR2(1);
749: BEGIN
750:
751: IF (l_debug = 'Y') THEN
752: okc_debug.set_indentation('Validate_Record');
753: okc_debug.log('in validate_record',1);
754: END IF;
755: -- ---------------------------------------------------------------------
756: -- Bug 1636056 related changes - Shyam

Line 753: okc_debug.log('in validate_record',1);

749: BEGIN
750:
751: IF (l_debug = 'Y') THEN
752: okc_debug.set_indentation('Validate_Record');
753: okc_debug.log('in validate_record',1);
754: END IF;
755: -- ---------------------------------------------------------------------
756: -- Bug 1636056 related changes - Shyam
757: -- OKC_UTIL.check_comp_unique call is replaced with

Line 763: okc_debug.log('100:invalidate_record',1);

759: -- uniqueness for LSE_ID + JTOT_OBJECT_CODE in OKC_LINE_STYLE_SOURCES_V
760: -- ---------------------------------------------------------------------
761: IF G_RECORD_STATUS = 'I' THEN
762: IF (l_debug = 'Y') THEN
763: okc_debug.log('100:invalidate_record',1);
764: END IF;
765: IF ( (p_lssv_rec.LSE_ID IS NOT NULL)
766: AND (p_lssv_rec.LSE_ID <> OKC_API.G_MISS_NUM) )
767: AND

Line 772: okc_debug.log('200:invalidate_record',1);

768: ( (p_lssv_rec.JTOT_OBJECT_CODE IS NOT NULL)
769: AND (p_lssv_rec.JTOT_OBJECT_CODE <> OKC_API.G_MISS_CHAR) )
770: THEN
771: IF (l_debug = 'Y') THEN
772: okc_debug.log('200:invalidate_record',1);
773: END IF;
774: OPEN cur_lss;
775: FETCH cur_lss INTO l_dummy;
776: l_row_found := cur_lss%FOUND;

Line 783: okc_debug.log('300:invalidate_record',1);

779: IF (l_row_found)
780: THEN
781:
782: IF (l_debug = 'Y') THEN
783: okc_debug.log('300:invalidate_record',1);
784: END IF;
785:
786: -- Display the newly defined error message
787: OKC_API.set_message(G_APP_NAME,

Line 796: okc_debug.log('005:invalidate_record',1);

792: -- the following code added for BUG#1932165 to call the validate_date_range when there is an
793: -- existing line style source with end date = null
794: ELSE
795: IF (l_debug = 'Y') THEN
796: okc_debug.log('005:invalidate_record',1);
797: END IF;
798: OPEN cur_lss_1;
799: FETCH cur_lss_1 INTO l_dummy;
800: l_row_found := cur_lss_1%FOUND;

Line 805: okc_debug.log('006:invalidate_record',1);

801: CLOSE cur_lss_1;
802: IF (l_row_found)
803: THEN
804: IF (l_debug = 'Y') THEN
805: okc_debug.log('006:invalidate_record',1);
806: END IF;
807: l_return_status:=VALIDATE_DATE_RANGE(p_lssv_rec);
808: END IF;
809: END IF;

Line 820: okc_debug.log('400:invalidate_record',1);

816: AND (p_lssv_rec.end_date IS NOT NULL
817: AND p_lssv_rec.end_date <> OKC_API.G_MISS_DATE ))
818: THEN
819: IF (l_debug = 'Y') THEN
820: okc_debug.log('400:invalidate_record',1);
821: END IF;
822:
823: OKC_API.set_message(G_APP_NAME,
824: G_INVALID_VALUE,

Line 830: okc_debug.log('500:invalidate_record',1);

826: 'Start Date > End Date');
827: l_return_status := OKC_API.G_RET_STS_ERROR;
828: ELSE
829: IF (l_debug = 'Y') THEN
830: okc_debug.log('500:invalidate_record',1);
831: END IF;
832:
833: l_return_status:=VALIDATE_DATE_RANGE(p_lssv_rec);
834: END IF;

Line 837: okc_debug.reset_indentation;

833: l_return_status:=VALIDATE_DATE_RANGE(p_lssv_rec);
834: END IF;
835: RETURN (l_return_status);
836: IF (l_debug = 'Y') THEN
837: okc_debug.reset_indentation;
838: END IF;
839: END Validate_Record;
840:
841: --**** end of change-------------------------------------------------------

Line 1057: okc_debug.set_indentation('insert_row');

1053: RETURN(l_return_status);
1054: END Set_Attributes;
1055: BEGIN
1056: IF (l_debug = 'Y') THEN
1057: okc_debug.set_indentation('insert_row');
1058: okc_debug.log('100:inside insert row',1 );
1059: END IF;
1060: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1061: p_init_msg_list,

Line 1058: okc_debug.log('100:inside insert row',1 );

1054: END Set_Attributes;
1055: BEGIN
1056: IF (l_debug = 'Y') THEN
1057: okc_debug.set_indentation('insert_row');
1058: okc_debug.log('100:inside insert row',1 );
1059: END IF;
1060: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1061: p_init_msg_list,
1062: '_PVT',

Line 1138: okc_debug.reset_indentation;

1134: x_msg_data,
1135: '_PVT'
1136: );
1137: IF (l_debug = 'Y') THEN
1138: okc_debug.reset_indentation;
1139: END IF;
1140: END insert_row;
1141: ---------------------------------------------
1142: -- insert_row for:OKC_LINE_STYLE_SOURCES_V --

Line 1706: okc_debug.set_indentation('update_row');

1702: RETURN(l_return_status);
1703: END Set_Attributes;
1704: BEGIN
1705: IF (l_debug = 'Y') THEN
1706: okc_debug.set_indentation('update_row');
1707: okc_debug.log('200:in update row',1);
1708: END IF;
1709: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1710: p_init_msg_list,

Line 1707: okc_debug.log('200:in update row',1);

1703: END Set_Attributes;
1704: BEGIN
1705: IF (l_debug = 'Y') THEN
1706: okc_debug.set_indentation('update_row');
1707: okc_debug.log('200:in update row',1);
1708: END IF;
1709: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1710: p_init_msg_list,
1711: '_PVT',

Line 1781: okc_debug.reset_indentation;

1777: x_msg_data,
1778: '_PVT'
1779: );
1780: IF (l_debug = 'Y') THEN
1781: okc_debug.reset_indentation;
1782: END IF;
1783: END update_row;
1784: ---------------------------------------------
1785: -- update_row for:OKC_LINE_STYLE_SOURCES_V --