DBA Data[Home] [Help]

APPS.OKC_OLE_PVT dependencies on OKC_OLE_PVT

Line 1: PACKAGE BODY OKC_OLE_PVT AS

1: PACKAGE BODY OKC_OLE_PVT AS
2: /* $Header: OKCSOLEB.pls 120.0 2005/05/25 19:19:39 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 31: okc_debug.Set_Indentation('OKC_OLE_PVT');

27: p_olev_rec IN olev_rec_type) is
28: Begin
29:
30: IF (l_debug = 'Y') THEN
31: okc_debug.Set_Indentation('OKC_OLE_PVT');
32: okc_debug.log('100: Entered validate_select_yn', 2);
33: END IF;
34:
35: -- initialize return status

Line 117: okc_debug.Set_Indentation('OKC_OLE_PVT');

113: p_olev_rec IN olev_rec_type) is
114: Begin
115:
116: IF (l_debug = 'Y') THEN
117: okc_debug.Set_Indentation('OKC_OLE_PVT');
118: okc_debug.log('500: Entered validate_active_yn', 2);
119: END IF;
120:
121: -- initialize return status

Line 203: okc_debug.Set_Indentation('OKC_OLE_PVT');

199: p_olev_rec IN olev_rec_type) is
200: Begin
201:
202: IF (l_debug = 'Y') THEN
203: okc_debug.Set_Indentation('OKC_OLE_PVT');
204: okc_debug.log('900: Entered validate_process_flag', 2);
205: END IF;
206:
207: -- initialize return status

Line 288: okc_debug.Set_Indentation('OKC_OLE_PVT');

284: WHERE id = p_oie_id;
285: Begin
286:
287: IF (l_debug = 'Y') THEN
288: okc_debug.Set_Indentation('OKC_OLE_PVT');
289: okc_debug.log('1300: Entered validate_oie_id', 2);
290: END IF;
291:
292: -- initialize return status

Line 385: okc_debug.Set_Indentation('OKC_OLE_PVT');

381:
382: Begin
383:
384: IF (l_debug = 'Y') THEN
385: okc_debug.Set_Indentation('OKC_OLE_PVT');
386: okc_debug.log('1700: Entered validate_parent_ole_id', 2);
387: END IF;
388:
389: -- initialize return status

Line 462: okc_debug.Set_Indentation('OKC_OLE_PVT');

458: WHERE id = p_subject_chr_id;
459: Begin
460:
461: IF (l_debug = 'Y') THEN
462: okc_debug.Set_Indentation('OKC_OLE_PVT');
463: okc_debug.log('2000: Entered validate_subject_chr_id', 2);
464: END IF;
465:
466: -- initialize return status

Line 559: okc_debug.Set_Indentation('OKC_OLE_PVT');

555:
556: Begin
557:
558: IF (l_debug = 'Y') THEN
559: okc_debug.Set_Indentation('OKC_OLE_PVT');
560: okc_debug.log('2400: Entered validate_object_chr_id', 2);
561: END IF;
562:
563: -- initialize return status

Line 638: okc_debug.Set_Indentation('OKC_OLE_PVT');

634:
635: Begin
636:
637: IF (l_debug = 'Y') THEN
638: okc_debug.Set_Indentation('OKC_OLE_PVT');
639: okc_debug.log('2700: Entered validate_object_cle_id', 2);
640: END IF;
641:
642: -- initialize return status

Line 717: okc_debug.Set_Indentation('OKC_OLE_PVT');

713:
714: Begin
715:
716: IF (l_debug = 'Y') THEN
717: okc_debug.Set_Indentation('OKC_OLE_PVT');
718: okc_debug.log('3000: Entered validate_subject_cle_id', 2);
719: END IF;
720:
721: -- initialize return status

Line 781: okc_debug.Set_Indentation('OKC_OLE_PVT');

777: p_olev_rec IN olev_rec_type) is
778: Begin
779:
780: IF (l_debug = 'Y') THEN
781: okc_debug.Set_Indentation('OKC_OLE_PVT');
782: okc_debug.log('3300: Entered validate_message_code', 2);
783: END IF;
784:
785: -- initialize return message

Line 923: okc_debug.Set_Indentation('OKC_OLE_PVT');

919: l_ole_rec ole_rec_type;
920: BEGIN
921:
922: IF (l_debug = 'Y') THEN
923: okc_debug.Set_Indentation('OKC_OLE_PVT');
924: okc_debug.log('4000: Entered get_rec', 2);
925: END IF;
926:
927: x_no_data_found := TRUE;

Line 1010: okc_debug.Set_Indentation('OKC_OLE_PVT');

1006: l_olev_rec olev_rec_type;
1007: BEGIN
1008:
1009: IF (l_debug = 'Y') THEN
1010: okc_debug.Set_Indentation('OKC_OLE_PVT');
1011: okc_debug.log('4200: Entered get_rec', 2);
1012: END IF;
1013:
1014: x_no_data_found := TRUE;

Line 1071: okc_debug.Set_Indentation('OKC_OLE_PVT');

1067: l_olev_rec olev_rec_type := p_olev_rec;
1068: BEGIN
1069:
1070: IF (l_debug = 'Y') THEN
1071: okc_debug.Set_Indentation('OKC_OLE_PVT');
1072: okc_debug.log('4400: Entered null_out_defaults', 2);
1073: END IF;
1074:
1075: IF (l_olev_rec.select_yn = OKC_API.G_MISS_CHAR) THEN

Line 1157: okc_debug.Set_Indentation('OKC_OLE_PVT');

1153: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1154: BEGIN
1155:
1156: IF (l_debug = 'Y') THEN
1157: okc_debug.Set_Indentation('OKC_OLE_PVT');
1158: okc_debug.log('4500: Entered Validate_Attributes', 2);
1159: END IF;
1160:
1161:

Line 1372: okc_debug.Set_Indentation('OKC_OLE_PVT');

1368: l_ole_rec ole_rec_type;
1369: BEGIN
1370:
1371: IF (l_debug = 'Y') THEN
1372: okc_debug.Set_Indentation('OKC_OLE_PVT');
1373: okc_debug.log('4900: Entered validate_row', 2);
1374: END IF;
1375:
1376: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1479: okc_debug.Set_Indentation('OKC_OLE_PVT');

1475: i NUMBER := 0;
1476: BEGIN
1477:
1478: IF (l_debug = 'Y') THEN
1479: okc_debug.Set_Indentation('OKC_OLE_PVT');
1480: okc_debug.log('5400: Entered validate_row', 2);
1481: END IF;
1482:
1483: OKC_API.init_msg_list(p_init_msg_list);

Line 1602: okc_debug.Set_Indentation('OKC_OLE_PVT');

1598: END Set_Attributes;
1599: BEGIN
1600:
1601: IF (l_debug = 'Y') THEN
1602: okc_debug.Set_Indentation('OKC_OLE_PVT');
1603: okc_debug.log('6000: Entered insert_row', 2);
1604: END IF;
1605:
1606: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1786: okc_debug.Set_Indentation('OKC_OLE_PVT');

1782: END Set_Attributes;
1783: BEGIN
1784:
1785: IF (l_debug = 'Y') THEN
1786: okc_debug.Set_Indentation('OKC_OLE_PVT');
1787: okc_debug.log('6700: Entered insert_row', 2);
1788: END IF;
1789:
1790: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1931: okc_debug.Set_Indentation('OKC_OLE_PVT');

1927: i NUMBER := 0;
1928: BEGIN
1929:
1930: IF (l_debug = 'Y') THEN
1931: okc_debug.Set_Indentation('OKC_OLE_PVT');
1932: okc_debug.log('7200: Entered insert_row', 2);
1933: END IF;
1934:
1935: OKC_API.init_msg_list(p_init_msg_list);

Line 2056: okc_debug.Set_Indentation('OKC_OLE_PVT');

2052: lc_row_notfound BOOLEAN := FALSE;
2053: BEGIN
2054:
2055: IF (l_debug = 'Y') THEN
2056: okc_debug.Set_Indentation('OKC_OLE_PVT');
2057: okc_debug.log('7700: Entered lock_row', 2);
2058: END IF;
2059:
2060: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2075: okc_debug.Set_Indentation('OKC_OLE_PVT');

2071:
2072: BEGIN
2073:
2074: IF (l_debug = 'Y') THEN
2075: okc_debug.Set_Indentation('OKC_OLE_PVT');
2076: okc_debug.log('7800: Entered lock_row', 2);
2077: END IF;
2078:
2079: OPEN lock_csr(p_ole_rec);

Line 2201: okc_debug.Set_Indentation('OKC_OLE_PVT');

2197: l_ole_rec ole_rec_type;
2198: BEGIN
2199:
2200: IF (l_debug = 'Y') THEN
2201: okc_debug.Set_Indentation('OKC_OLE_PVT');
2202: okc_debug.log('8500: Entered lock_row', 2);
2203: END IF;
2204:
2205: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2313: okc_debug.Set_Indentation('OKC_OLE_PVT');

2309: i NUMBER := 0;
2310: BEGIN
2311:
2312: IF (l_debug = 'Y') THEN
2313: okc_debug.Set_Indentation('OKC_OLE_PVT');
2314: okc_debug.log('9000: Entered lock_row', 2);
2315: END IF;
2316:
2317: OKC_API.init_msg_list(p_init_msg_list);

Line 2434: okc_debug.Set_Indentation('OKC_OLE_PVT');

2430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2431: BEGIN
2432:
2433: IF (l_debug = 'Y') THEN
2434: okc_debug.Set_Indentation('OKC_OLE_PVT');
2435: okc_debug.log('9500: Entered populate_new_record', 2);
2436: END IF;
2437:
2438: x_ole_rec := p_ole_rec;

Line 2554: okc_debug.Set_Indentation('OKC_OLE_PVT');

2550: END Set_Attributes;
2551: BEGIN
2552:
2553: IF (l_debug = 'Y') THEN
2554: okc_debug.Set_Indentation('OKC_OLE_PVT');
2555: okc_debug.log('9700: Entered update_row', 2);
2556: END IF;
2557:
2558: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2712: okc_debug.Set_Indentation('OKC_OLE_PVT');

2708: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2709: BEGIN
2710:
2711: IF (l_debug = 'Y') THEN
2712: okc_debug.Set_Indentation('OKC_OLE_PVT');
2713: okc_debug.log('10300: Entered populate_new_record', 2);
2714: END IF;
2715:
2716: x_olev_rec := p_olev_rec;

Line 2836: okc_debug.Set_Indentation('OKC_OLE_PVT');

2832: END Set_Attributes;
2833: BEGIN
2834:
2835: IF (l_debug = 'Y') THEN
2836: okc_debug.Set_Indentation('OKC_OLE_PVT');
2837: okc_debug.log('10500: Entered update_row', 2);
2838: END IF;
2839:
2840: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2984: okc_debug.Set_Indentation('OKC_OLE_PVT');

2980: i NUMBER := 0;
2981: BEGIN
2982:
2983: IF (l_debug = 'Y') THEN
2984: okc_debug.Set_Indentation('OKC_OLE_PVT');
2985: okc_debug.log('11000: Entered update_row', 2);
2986: END IF;
2987:
2988: OKC_API.init_msg_list(p_init_msg_list);

Line 3094: okc_debug.Set_Indentation('OKC_OLE_PVT');

3090: l_row_notfound BOOLEAN := TRUE;
3091: BEGIN
3092:
3093: IF (l_debug = 'Y') THEN
3094: okc_debug.Set_Indentation('OKC_OLE_PVT');
3095: okc_debug.log('11500: Entered delete_row', 2);
3096: END IF;
3097:
3098: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3187: okc_debug.Set_Indentation('OKC_OLE_PVT');

3183: l_ole_rec ole_rec_type;
3184: BEGIN
3185:
3186: IF (l_debug = 'Y') THEN
3187: okc_debug.Set_Indentation('OKC_OLE_PVT');
3188: okc_debug.log('12000: Entered delete_row', 2);
3189: END IF;
3190:
3191: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3299: okc_debug.Set_Indentation('OKC_OLE_PVT');

3295: i NUMBER := 0;
3296: BEGIN
3297:
3298: IF (l_debug = 'Y') THEN
3299: okc_debug.Set_Indentation('OKC_OLE_PVT');
3300: okc_debug.log('12500: Entered delete_row', 2);
3301: END IF;
3302:
3303: OKC_API.init_msg_list(p_init_msg_list);

Line 3387: END OKC_OLE_PVT;

3383: );
3384:
3385: END delete_row;
3386:
3387: END OKC_OLE_PVT;