DBA Data[Home] [Help]

APPS.OKC_CIM_PVT dependencies on OKC_CIM_PVT

Line 1: PACKAGE BODY OKC_CIM_PVT AS

1: PACKAGE BODY OKC_CIM_PVT AS
2: /* $Header: OKCSCIMB.pls 120.1 2005/11/23 01:23:39 jvorugan noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: /*+++++++++++++Start of hand code +++++++++++++++++*/

Line 92: okc_debug.Set_Indentation('OKC_CIM_PVT');

88: l_cim_rec cim_rec_type;
89: BEGIN
90:
91: IF (l_debug = 'Y') THEN
92: okc_debug.Set_Indentation('OKC_CIM_PVT');
93: okc_debug.log('500: Entered get_rec', 2);
94: END IF;
95:
96: x_no_data_found := TRUE;

Line 185: okc_debug.Set_Indentation('OKC_CIM_PVT');

181: l_cimv_rec cimv_rec_type;
182: BEGIN
183:
184: IF (l_debug = 'Y') THEN
185: okc_debug.Set_Indentation('OKC_CIM_PVT');
186: okc_debug.log('700: Entered get_rec', 2);
187: END IF;
188:
189: x_no_data_found := TRUE;

Line 250: okc_debug.Set_Indentation('OKC_CIM_PVT');

246: l_cimv_rec cimv_rec_type := p_cimv_rec;
247: BEGIN
248:
249: IF (l_debug = 'Y') THEN
250: okc_debug.Set_Indentation('OKC_CIM_PVT');
251: okc_debug.log('900: Entered null_out_defaults', 2);
252: END IF;
253:
254: IF (l_cimv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 355: okc_debug.Set_Indentation('OKC_CIM_PVT');

351: where id = p_cimv_rec.cle_id;
352: begin
353:
354: IF (l_debug = 'Y') THEN
355: okc_debug.Set_Indentation('OKC_CIM_PVT');
356: okc_debug.log('1000: Entered validate_cle_id', 2);
357: END IF;
358:
359: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 431: okc_debug.Set_Indentation('OKC_CIM_PVT');

427: where id = p_cimv_rec.cle_id_for;
428: begin
429:
430: IF (l_debug = 'Y') THEN
431: okc_debug.Set_Indentation('OKC_CIM_PVT');
432: okc_debug.log('1400: Entered validate_cle_id_for', 2);
433: END IF;
434:
435: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 492: okc_debug.Set_Indentation('OKC_CIM_PVT');

488: where id = p_cimv_rec.chr_id;
489: begin
490:
491: IF (l_debug = 'Y') THEN
492: okc_debug.Set_Indentation('OKC_CIM_PVT');
493: okc_debug.log('1700: Entered validate_chr_id', 2);
494: END IF;
495:
496: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 548: okc_debug.Set_Indentation('OKC_CIM_PVT');

544: p_cimv_rec IN CIMV_REC_TYPE) is
545: begin
546:
547: IF (l_debug = 'Y') THEN
548: okc_debug.Set_Indentation('OKC_CIM_PVT');
549: okc_debug.log('2000: Entered validate_exception_yn', 2);
550: END IF;
551:
552: if (p_cimv_rec.exception_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then

Line 579: okc_debug.Set_Indentation('OKC_CIM_PVT');

575: p_cimv_rec IN CIMV_REC_TYPE) is
576: begin
577:
578: IF (l_debug = 'Y') THEN
579: okc_debug.Set_Indentation('OKC_CIM_PVT');
580: okc_debug.log('2100: Entered validate_priced_item_yn', 2);
581: END IF;
582:
583: if (p_cimv_rec.priced_item_yn is NULL or p_cimv_rec.priced_item_yn in ('Y','N',OKC_API.G_MISS_CHAR)) then

Line 616: okc_debug.Set_Indentation('OKC_CIM_PVT');

612: where UOM_CODE = p_cimv_rec.UOM_CODE;
613: begin
614:
615: IF (l_debug = 'Y') THEN
616: okc_debug.Set_Indentation('OKC_CIM_PVT');
617: okc_debug.log('2200: Entered validate_UOM_CODE', 2);
618: END IF;
619:
620: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 691: okc_debug.Set_Indentation('OKC_CIM_PVT');

687:
688: begin
689:
690: IF (l_debug = 'Y') THEN
691: okc_debug.Set_Indentation('OKC_CIM_PVT');
692: okc_debug.log('2500: Entered validate_JTOT_OBJECT1_CODE', 2);
693: END IF;
694:
695: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 769: okc_debug.Set_Indentation('OKC_CIM_PVT');

765:
766: begin
767:
768: IF (l_debug = 'Y') THEN
769: okc_debug.Set_Indentation('OKC_CIM_PVT');
770: okc_debug.log('2800: Entered validate_object1_id1', 2);
771: END IF;
772:
773: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 873: okc_debug.Set_Indentation('OKC_CIM_PVT');

869: where id = p_cimv_rec.dnz_chr_id;
870: begin
871:
872: IF (l_debug = 'Y') THEN
873: okc_debug.Set_Indentation('OKC_CIM_PVT');
874: okc_debug.log('3500: Entered validate_dnz_chr_id', 2);
875: END IF;
876:
877: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 933: okc_debug.Set_Indentation('OKC_CIM_PVT');

929: /*-------------Commented in favor of hand code------
930: BEGIN
931:
932: IF (l_debug = 'Y') THEN
933: okc_debug.Set_Indentation('OKC_CIM_PVT');
934: okc_debug.log('3800: Entered Validate_Attributes', 2);
935: END IF;
936:
937: IF p_cimv_rec.id = OKC_API.G_MISS_NUM OR

Line 1099: okc_debug.Set_Indentation('OKC_CIM_PVT');

1095:
1096: BEGIN
1097:
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.Set_Indentation('OKC_CIM_PVT');
1100: okc_debug.log('3900: Entered Validate_Record', 2);
1101: END IF;
1102:
1103: if ((p_cimv_rec.chr_id IS NOT NULL and p_cimv_rec.chr_id <> OKC_API.G_MISS_NUM) and

Line 1270: okc_debug.Set_Indentation('OKC_CIM_PVT');

1266: l_cim_rec cim_rec_type;
1267: BEGIN
1268:
1269: IF (l_debug = 'Y') THEN
1270: okc_debug.Set_Indentation('OKC_CIM_PVT');
1271: okc_debug.log('4400: Entered validate_row', 2);
1272: END IF;
1273:
1274: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1376: okc_debug.Set_Indentation('OKC_CIM_PVT');

1372: i NUMBER := 0;
1373: BEGIN
1374:
1375: IF (l_debug = 'Y') THEN
1376: okc_debug.Set_Indentation('OKC_CIM_PVT');
1377: okc_debug.log('4900: Entered validate_row', 2);
1378: END IF;
1379:
1380: OKC_API.init_msg_list(p_init_msg_list);

Line 1491: okc_debug.Set_Indentation('OKC_CIM_PVT');

1487: END Set_Attributes;
1488: BEGIN
1489:
1490: IF (l_debug = 'Y') THEN
1491: okc_debug.Set_Indentation('OKC_CIM_PVT');
1492: okc_debug.log('5500: Entered insert_row', 2);
1493: END IF;
1494:
1495: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1680: okc_debug.Set_Indentation('OKC_CIM_PVT');

1676: END Set_Attributes;
1677: BEGIN
1678:
1679: IF (l_debug = 'Y') THEN
1680: okc_debug.Set_Indentation('OKC_CIM_PVT');
1681: okc_debug.log('6200: Entered insert_row', 2);
1682: END IF;
1683:
1684: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1824: okc_debug.Set_Indentation('OKC_CIM_PVT');

1820: i NUMBER := 0;
1821: BEGIN
1822:
1823: IF (l_debug = 'Y') THEN
1824: okc_debug.Set_Indentation('OKC_CIM_PVT');
1825: okc_debug.log('6700: Entered insert_row', 2);
1826: END IF;
1827:
1828: OKC_API.init_msg_list(p_init_msg_list);

Line 1939: okc_debug.Set_Indentation('OKC_CIM_PVT');

1935: lc_row_notfound BOOLEAN := FALSE;
1936: BEGIN
1937:
1938: IF (l_debug = 'Y') THEN
1939: okc_debug.Set_Indentation('OKC_CIM_PVT');
1940: okc_debug.log('7200: Entered lock_row', 2);
1941: END IF;
1942:
1943: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1955: okc_debug.Set_Indentation('OKC_CIM_PVT');

1951: END IF;
1952: BEGIN
1953:
1954: IF (l_debug = 'Y') THEN
1955: okc_debug.Set_Indentation('OKC_CIM_PVT');
1956: okc_debug.log('7300: Entered lock_row', 2);
1957: END IF;
1958:
1959: OPEN lock_csr(p_cim_rec);

Line 2079: okc_debug.Set_Indentation('OKC_CIM_PVT');

2075: l_cim_rec cim_rec_type;
2076: BEGIN
2077:
2078: IF (l_debug = 'Y') THEN
2079: okc_debug.Set_Indentation('OKC_CIM_PVT');
2080: okc_debug.log('8000: Entered lock_row', 2);
2081: END IF;
2082:
2083: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2190: okc_debug.Set_Indentation('OKC_CIM_PVT');

2186: i NUMBER := 0;
2187: BEGIN
2188:
2189: IF (l_debug = 'Y') THEN
2190: okc_debug.Set_Indentation('OKC_CIM_PVT');
2191: okc_debug.log('8500: Entered lock_row', 2);
2192: END IF;
2193:
2194: OKC_API.init_msg_list(p_init_msg_list);

Line 2301: okc_debug.Set_Indentation('OKC_CIM_PVT');

2297: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2298: BEGIN
2299:
2300: IF (l_debug = 'Y') THEN
2301: okc_debug.Set_Indentation('OKC_CIM_PVT');
2302: okc_debug.log('9000: Entered populate_new_record', 2);
2303: END IF;
2304:
2305: x_cim_rec := p_cim_rec;

Line 2433: okc_debug.Set_Indentation('OKC_CIM_PVT');

2429: END Set_Attributes;
2430: BEGIN
2431:
2432: IF (l_debug = 'Y') THEN
2433: okc_debug.Set_Indentation('OKC_CIM_PVT');
2434: okc_debug.log('9200: Entered update_row', 2);
2435: END IF;
2436:
2437: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2595: okc_debug.Set_Indentation('OKC_CIM_PVT');

2591: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2592: BEGIN
2593:
2594: IF (l_debug = 'Y') THEN
2595: okc_debug.Set_Indentation('OKC_CIM_PVT');
2596: okc_debug.log('9800: Entered populate_new_record', 2);
2597: END IF;
2598:
2599: x_cimv_rec := p_cimv_rec;

Line 2706: okc_debug.Set_Indentation('OKC_CIM_PVT');

2702: END IF;
2703:
2704:
2705: IF (l_debug = 'Y') THEN
2706: okc_debug.Set_Indentation('OKC_CIM_PVT');
2707: okc_debug.log('9900: Leaving populate_new_record', 2);
2708: END IF;
2709:
2710: RETURN(l_return_status);

Line 2731: okc_debug.Set_Indentation('OKC_CIM_PVT');

2727: END Set_Attributes;
2728: BEGIN
2729:
2730: IF (l_debug = 'Y') THEN
2731: okc_debug.Set_Indentation('OKC_CIM_PVT');
2732: okc_debug.log('10000: Entered update_row', 2);
2733: END IF;
2734:
2735: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2878: okc_debug.Set_Indentation('OKC_CIM_PVT');

2874: i NUMBER := 0;
2875: BEGIN
2876:
2877: IF (l_debug = 'Y') THEN
2878: okc_debug.Set_Indentation('OKC_CIM_PVT');
2879: okc_debug.log('10500: Entered update_row', 2);
2880: END IF;
2881:
2882: OKC_API.init_msg_list(p_init_msg_list);

Line 2978: okc_debug.Set_Indentation('OKC_CIM_PVT');

2974: l_row_notfound BOOLEAN := TRUE;
2975: BEGIN
2976:
2977: IF (l_debug = 'Y') THEN
2978: okc_debug.Set_Indentation('OKC_CIM_PVT');
2979: okc_debug.log('11000: Entered delete_row', 2);
2980: END IF;
2981:
2982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3071: okc_debug.Set_Indentation('OKC_CIM_PVT');

3067: l_cim_rec cim_rec_type;
3068: BEGIN
3069:
3070: IF (l_debug = 'Y') THEN
3071: okc_debug.Set_Indentation('OKC_CIM_PVT');
3072: okc_debug.log('11500: Entered delete_row', 2);
3073: END IF;
3074:
3075: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3182: okc_debug.Set_Indentation('OKC_CIM_PVT');

3178: i NUMBER := 0;
3179: BEGIN
3180:
3181: IF (l_debug = 'Y') THEN
3182: okc_debug.Set_Indentation('OKC_CIM_PVT');
3183: okc_debug.log('12000: Entered delete_row', 2);
3184: END IF;
3185:
3186: OKC_API.init_msg_list(p_init_msg_list);

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

3295: -- Initializing return status
3296: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3297:
3298: IF (l_debug = 'Y') THEN
3299: okc_debug.Set_Indentation('OKC_CIM_PVT');
3300: okc_debug.log('12500: Entered INSERT_ROW_UPG', 2);
3301: END IF;
3302:
3303: -- pkoganti 08/26/2000

Line 3449: okc_debug.Set_Indentation('OKC_CIM_PVT');

3445:
3446: BEGIN
3447:
3448: IF (l_debug = 'Y') THEN
3449: okc_debug.Set_Indentation('OKC_CIM_PVT');
3450: okc_debug.log('12800: Entered create_version', 2);
3451: END IF;
3452:
3453: INSERT INTO okc_k_items_h

Line 3551: okc_debug.Set_Indentation('OKC_CIM_PVT');

3547:
3548: BEGIN
3549:
3550: IF (l_debug = 'Y') THEN
3551: okc_debug.Set_Indentation('OKC_CIM_PVT');
3552: okc_debug.log('13100: Entered restore_version', 2);
3553: END IF;
3554:
3555: INSERT INTO okc_k_items

Line 3637: END OKC_CIM_PVT;

3633: return l_return_status;
3634:
3635: END restore_version;
3636:
3637: END OKC_CIM_PVT;