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_CTC_PVT dependencies on OKC_CTC_PVT

Line 1: PACKAGE BODY OKC_CTC_PVT AS

1: PACKAGE BODY OKC_CTC_PVT AS
2: /* $Header: OKCSCTCB.pls 120.4 2011/03/10 18:11:34 harchand ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: /*+++++++++++++Start of hand code +++++++++++++++++*/

Line 67: okc_debug.Set_Indentation('OKC_CTC_PVT');

63: l_ste_code varchar2(30);
64:
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: okc_debug.Set_Indentation('OKC_CTC_PVT');
68: okc_debug.log('100: Entered update_contact_stecode', 2);
69: END IF;
70:
71: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 84: okc_debug.Set_Indentation('OKC_CTC_PVT');

80:
81: UPDATE OKC_CONTACTS SET dnz_ste_code=l_ste_code WHERE DNZ_CHR_ID=p_chr_id;
82:
83: IF (l_debug = 'Y') THEN
84: okc_debug.Set_Indentation('OKC_CTC_PVT');
85: okc_debug.log('110: Exiting update_contact_stecode', 2);
86: END IF;
87:
88: EXCEPTION

Line 160: okc_debug.Set_Indentation('OKC_CTC_PVT');

156: l_ctc_rec ctc_rec_type;
157: BEGIN
158:
159: IF (l_debug = 'Y') THEN
160: okc_debug.Set_Indentation('OKC_CTC_PVT');
161: okc_debug.log('500: Entered get_rec', 2);
162: END IF;
163:
164: x_no_data_found := TRUE;

Line 276: okc_debug.Set_Indentation('OKC_CTC_PVT');

272: l_ctcv_rec ctcv_rec_type;
273: BEGIN
274:
275: IF (l_debug = 'Y') THEN
276: okc_debug.Set_Indentation('OKC_CTC_PVT');
277: okc_debug.log('700: Entered get_rec', 2);
278: END IF;
279:
280: x_no_data_found := TRUE;

Line 351: okc_debug.Set_Indentation('OKC_CTC_PVT');

347: l_ctcv_rec ctcv_rec_type := p_ctcv_rec;
348: BEGIN
349:
350: IF (l_debug = 'Y') THEN
351: okc_debug.Set_Indentation('OKC_CTC_PVT');
352: okc_debug.log('900: Entered null_out_defaults', 2);
353: END IF;
354:
355: IF (l_ctcv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 490: okc_debug.Set_Indentation('OKC_CTC_PVT');

486: where id = p_ctcv_rec.cpl_id;
487: begin
488:
489: IF (l_debug = 'Y') THEN
490: okc_debug.Set_Indentation('OKC_CTC_PVT');
491: okc_debug.log('1000: Entered validate_cpl_id', 2);
492: END IF;
493:
494: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 563: okc_debug.Set_Indentation('OKC_CTC_PVT');

559: --
560: begin
561:
562: IF (l_debug = 'Y') THEN
563: okc_debug.Set_Indentation('OKC_CTC_PVT');
564: okc_debug.log('1400: Entered validate_cro_code', 2);
565: END IF;
566:
567: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 648: okc_debug.Set_Indentation('OKC_CTC_PVT');

644: ;
645: begin
646:
647: IF (l_debug = 'Y') THEN
648: okc_debug.Set_Indentation('OKC_CTC_PVT');
649: okc_debug.log('1800: Entered validate_JTOT_OBJECT1_CODE', 2);
650: END IF;
651:
652: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 888: okc_debug.Set_Indentation('OKC_CTC_PVT');

884: END;
885: begin
886:
887: IF (l_debug = 'Y') THEN
888: okc_debug.Set_Indentation('OKC_CTC_PVT');
889: okc_debug.log('2100: Entered validate_object1_id1', 2);
890: END IF;
891:
892: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 914: okc_debug.Set_Indentation('OKC_CTC_PVT');

910: if (l_dummy_var = 'N') then
911: begin
912:
913: IF (l_debug = 'Y') THEN
914: okc_debug.Set_Indentation('OKC_CTC_PVT');
915: okc_debug.log('2200: Entered validate_object1_id1', 2);
916: END IF;
917:
918: EXECUTE IMMEDIATE 'select ''x'' from '||l_from_table||

Line 954: okc_debug.Set_Indentation('OKC_CTC_PVT');

950: else
951: begin
952:
953: IF (l_debug = 'Y') THEN
954: okc_debug.Set_Indentation('OKC_CTC_PVT');
955: okc_debug.log('2600: Entered validate_object1_id1', 2);
956: END IF;
957:
958:

Line 1080: okc_debug.Set_Indentation('OKC_CTC_PVT');

1076: where id = p_ctcv_rec.dnz_chr_id;
1077: begin
1078:
1079: IF (l_debug = 'Y') THEN
1080: okc_debug.Set_Indentation('OKC_CTC_PVT');
1081: okc_debug.log('3500: Entered validate_dnz_chr_id', 2);
1082: END IF;
1083:
1084: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1308: okc_debug.Set_Indentation('OKC_CTC_PVT');

1304: x_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
1305: BEGIN
1306:
1307: IF (l_debug = 'Y') THEN
1308: okc_debug.Set_Indentation('OKC_CTC_PVT');
1309: okc_debug.log('3800: Entered Validate_Attributes', 2);
1310: END IF;
1311:
1312: -- call each column-level validation

Line 1459: okc_debug.Set_Indentation('OKC_CTC_PVT');

1455:
1456: BEGIN
1457:
1458: IF (l_debug = 'Y') THEN
1459: okc_debug.Set_Indentation('OKC_CTC_PVT');
1460: okc_debug.log('4100: Entered Validate_Record', 2);
1461: END IF;
1462:
1463: -- indirection

Line 1697: okc_debug.Set_Indentation('OKC_CTC_PVT');

1693: l_ctc_rec ctc_rec_type;
1694: BEGIN
1695:
1696: IF (l_debug = 'Y') THEN
1697: okc_debug.Set_Indentation('OKC_CTC_PVT');
1698: okc_debug.log('4600: Entered validate_row', 2);
1699: END IF;
1700:
1701: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1803: okc_debug.Set_Indentation('OKC_CTC_PVT');

1799: i NUMBER := 0;
1800: BEGIN
1801:
1802: IF (l_debug = 'Y') THEN
1803: okc_debug.Set_Indentation('OKC_CTC_PVT');
1804: okc_debug.log('5100: Entered validate_row', 2);
1805: END IF;
1806:
1807: OKC_API.init_msg_list(p_init_msg_list);

Line 1919: okc_debug.Set_Indentation('OKC_CTC_PVT');

1915: END Set_Attributes;
1916: BEGIN
1917:
1918: IF (l_debug = 'Y') THEN
1919: okc_debug.Set_Indentation('OKC_CTC_PVT');
1920: okc_debug.log('5700: Entered insert_row', 2);
1921: END IF;
1922:
1923: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2138: okc_debug.Set_Indentation('OKC_CTC_PVT');

2134: END Set_Attributes;
2135: BEGIN
2136:
2137: IF (l_debug = 'Y') THEN
2138: okc_debug.Set_Indentation('OKC_CTC_PVT');
2139: okc_debug.log('6400: Entered insert_row', 2);
2140: END IF;
2141:
2142: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2282: okc_debug.Set_Indentation('OKC_CTC_PVT');

2278: i NUMBER := 0;
2279: BEGIN
2280:
2281: IF (l_debug = 'Y') THEN
2282: okc_debug.Set_Indentation('OKC_CTC_PVT');
2283: okc_debug.log('6900: Entered insert_row', 2);
2284: END IF;
2285:
2286: OKC_API.init_msg_list(p_init_msg_list);

Line 2397: okc_debug.Set_Indentation('OKC_CTC_PVT');

2393: lc_row_notfound BOOLEAN := FALSE;
2394: BEGIN
2395:
2396: IF (l_debug = 'Y') THEN
2397: okc_debug.Set_Indentation('OKC_CTC_PVT');
2398: okc_debug.log('7400: Entered lock_row', 2);
2399: END IF;
2400:
2401: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2413: okc_debug.Set_Indentation('OKC_CTC_PVT');

2409: END IF;
2410: BEGIN
2411:
2412: IF (l_debug = 'Y') THEN
2413: okc_debug.Set_Indentation('OKC_CTC_PVT');
2414: okc_debug.log('7500: Entered lock_row', 2);
2415: END IF;
2416:
2417: OPEN lock_csr(p_ctc_rec);

Line 2537: okc_debug.Set_Indentation('OKC_CTC_PVT');

2533: l_ctc_rec ctc_rec_type;
2534: BEGIN
2535:
2536: IF (l_debug = 'Y') THEN
2537: okc_debug.Set_Indentation('OKC_CTC_PVT');
2538: okc_debug.log('8200: Entered lock_row', 2);
2539: END IF;
2540:
2541: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2648: okc_debug.Set_Indentation('OKC_CTC_PVT');

2644: i NUMBER := 0;
2645: BEGIN
2646:
2647: IF (l_debug = 'Y') THEN
2648: okc_debug.Set_Indentation('OKC_CTC_PVT');
2649: okc_debug.log('8700: Entered lock_row', 2);
2650: END IF;
2651:
2652: OKC_API.init_msg_list(p_init_msg_list);

Line 2771: okc_debug.Set_Indentation('OKC_CTC_PVT');

2767: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2768: BEGIN
2769:
2770: IF (l_debug = 'Y') THEN
2771: okc_debug.Set_Indentation('OKC_CTC_PVT');
2772: okc_debug.log('9200: Entered populate_new_record', 2);
2773: END IF;
2774:
2775: x_ctc_rec := p_ctc_rec;

Line 2953: okc_debug.Set_Indentation('OKC_CTC_PVT');

2949: END Set_Attributes;
2950: BEGIN
2951:
2952: IF (l_debug = 'Y') THEN
2953: okc_debug.Set_Indentation('OKC_CTC_PVT');
2954: okc_debug.log('9400: Entered update_row', 2);
2955: END IF;
2956:
2957: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3132: okc_debug.Set_Indentation('OKC_CTC_PVT');

3128: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3129: BEGIN
3130:
3131: IF (l_debug = 'Y') THEN
3132: okc_debug.Set_Indentation('OKC_CTC_PVT');
3133: okc_debug.log('10000: Entered populate_new_record', 2);
3134: END IF;
3135:
3136: x_ctcv_rec := p_ctcv_rec;

Line 3311: okc_debug.Set_Indentation('OKC_CTC_PVT');

3307: END Set_Attributes;
3308: BEGIN
3309:
3310: IF (l_debug = 'Y') THEN
3311: okc_debug.Set_Indentation('OKC_CTC_PVT');
3312: okc_debug.log('10200: Entered update_row', 2);
3313: END IF;
3314:
3315: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3458: okc_debug.Set_Indentation('OKC_CTC_PVT');

3454: i NUMBER := 0;
3455: BEGIN
3456:
3457: IF (l_debug = 'Y') THEN
3458: okc_debug.Set_Indentation('OKC_CTC_PVT');
3459: okc_debug.log('10700: Entered update_row', 2);
3460: END IF;
3461:
3462: OKC_API.init_msg_list(p_init_msg_list);

Line 3558: okc_debug.Set_Indentation('OKC_CTC_PVT');

3554: l_row_notfound BOOLEAN := TRUE;
3555: BEGIN
3556:
3557: IF (l_debug = 'Y') THEN
3558: okc_debug.Set_Indentation('OKC_CTC_PVT');
3559: okc_debug.log('11200: Entered delete_row', 2);
3560: END IF;
3561:
3562: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3651: okc_debug.Set_Indentation('OKC_CTC_PVT');

3647: l_ctc_rec ctc_rec_type;
3648: BEGIN
3649:
3650: IF (l_debug = 'Y') THEN
3651: okc_debug.Set_Indentation('OKC_CTC_PVT');
3652: okc_debug.log('11700: Entered delete_row', 2);
3653: END IF;
3654:
3655: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3762: okc_debug.Set_Indentation('OKC_CTC_PVT');

3758: i NUMBER := 0;
3759: BEGIN
3760:
3761: IF (l_debug = 'Y') THEN
3762: okc_debug.Set_Indentation('OKC_CTC_PVT');
3763: okc_debug.log('12200: Entered delete_row', 2);
3764: END IF;
3765:
3766: OKC_API.init_msg_list(p_init_msg_list);

Line 3898: okc_debug.Set_Indentation('OKC_CTC_PVT');

3894: -- initialize return status
3895: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3896:
3897: IF (l_debug = 'Y') THEN
3898: okc_debug.Set_Indentation('OKC_CTC_PVT');
3899: okc_debug.log('12700: Entered INSERT_ROW_UPG', 2);
3900: END IF;
3901:
3902: i := p_ctcv_tbl.FIRST; j:=0;

Line 4078: okc_debug.Set_Indentation('OKC_CTC_PVT');

4074:
4075: BEGIN
4076:
4077: IF (l_debug = 'Y') THEN
4078: okc_debug.Set_Indentation('OKC_CTC_PVT');
4079: okc_debug.log('13000: Entered create_version', 2);
4080: END IF;
4081:
4082: INSERT INTO okc_contacts_h

Line 4205: okc_debug.Set_Indentation('OKC_CTC_PVT');

4201:
4202: BEGIN
4203:
4204: IF (l_debug = 'Y') THEN
4205: okc_debug.Set_Indentation('OKC_CTC_PVT');
4206: okc_debug.log('13300: Entered restore_version', 2);
4207: END IF;
4208:
4209: INSERT INTO okc_contacts

Line 4288: OKC_CTC_PVT.update_contact_stecode(p_chr_id => p_chr_id,

4284: WHERE dnz_chr_id = p_chr_id
4285: AND major_version = p_major_version;
4286:
4287: /* Bug fix for 6882512*/
4288: OKC_CTC_PVT.update_contact_stecode(p_chr_id => p_chr_id,
4289: x_return_status=>l_return_status);
4290:
4291: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4292: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4326: END OKC_CTC_PVT;

4322: return l_return_status;
4323:
4324: END restore_version;
4325:
4326: END OKC_CTC_PVT;