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_CPL_PVT dependencies on OKC_CPL_PVT

Line 1: PACKAGE BODY OKC_CPL_PVT AS

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

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

57: PROCEDURE add_language IS
58: BEGIN
59:
60: IF (l_debug = 'Y') THEN
61: okc_debug.Set_Indentation('OKC_CPL_PVT');
62: okc_debug.log('500: Entered add_language', 2);
63: END IF;
64:
65: /* Mar/19/03 requested by Ric Ginsberg */

Line 280: okc_debug.Set_Indentation('OKC_CPL_PVT');

276: l_cpl_rec cpl_rec_type;
277: BEGIN
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.Set_Indentation('OKC_CPL_PVT');
281: okc_debug.log('600: Entered get_rec', 2);
282: END IF;
283:
284: x_no_data_found := TRUE;

Line 382: okc_debug.Set_Indentation('OKC_CPL_PVT');

378: l_okc_k_party_roles_tl_rec okc_k_party_roles_tl_rec_type;
379: BEGIN
380:
381: IF (l_debug = 'Y') THEN
382: okc_debug.Set_Indentation('OKC_CPL_PVT');
383: okc_debug.log('800: Entered get_rec', 2);
384: END IF;
385:
386: x_no_data_found := TRUE;

Line 406: okc_debug.Set_Indentation('OKC_CPL_PVT');

402: x_no_data_found := cpl_pktl_csr%NOTFOUND;
403: CLOSE cpl_pktl_csr;
404:
405: IF (l_debug = 'Y') THEN
406: okc_debug.Set_Indentation('OKC_CPL_PVT');
407: okc_debug.log('900: Entered get_rec', 2);
408: END IF;
409:
410: RETURN(l_okc_k_party_roles_tl_rec);

Line 480: okc_debug.Set_Indentation('OKC_CPL_PVT');

476: l_cplv_rec cplv_rec_type;
477: BEGIN
478:
479: IF (l_debug = 'Y') THEN
480: okc_debug.Set_Indentation('OKC_CPL_PVT');
481: okc_debug.log('1000: Entered get_rec', 2);
482: END IF;
483:
484: x_no_data_found := TRUE;

Line 533: okc_debug.Set_Indentation('OKC_CPL_PVT');

529: x_no_data_found := okc_cplv_pk_csr%NOTFOUND;
530: CLOSE okc_cplv_pk_csr;
531:
532: IF (l_debug = 'Y') THEN
533: okc_debug.Set_Indentation('OKC_CPL_PVT');
534: okc_debug.log('1050: Entered get_rec', 2);
535: END IF;
536:
537: RETURN(l_cplv_rec);

Line 561: okc_debug.Set_Indentation('OKC_CPL_PVT');

557: l_cplv_rec cplv_rec_type := p_cplv_rec;
558: BEGIN
559:
560: IF (l_debug = 'Y') THEN
561: okc_debug.Set_Indentation('OKC_CPL_PVT');
562: okc_debug.log('1200: Entered null_out_defaults', 2);
563: END IF;
564:
565: IF (l_cplv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

Line 690: okc_debug.Set_Indentation('OKC_CPL_PVT');

686: l_cplv_rec.last_update_login := NULL;
687: END IF;
688:
689: IF (l_debug = 'Y') THEN
690: okc_debug.Set_Indentation('OKC_CPL_PVT');
691: okc_debug.log('1150: Entered get_rec', 2);
692: END IF;
693:
694: RETURN(l_cplv_rec);

Line 721: okc_debug.Set_Indentation('OKC_CPL_PVT');

717: where id = p_cplv_rec.cle_id;
718: begin
719:
720: IF (l_debug = 'Y') THEN
721: okc_debug.Set_Indentation('OKC_CPL_PVT');
722: okc_debug.log('1300: Entered validate_cle_id', 2);
723: END IF;
724:
725: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 793: okc_debug.Set_Indentation('OKC_CPL_PVT');

789: where id = p_cplv_rec.cpl_id;
790: begin
791:
792: IF (l_debug = 'Y') THEN
793: okc_debug.Set_Indentation('OKC_CPL_PVT');
794: okc_debug.log('1700: Entered validate_cpl_id', 2);
795: END IF;
796:
797: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 858: okc_debug.Set_Indentation('OKC_CPL_PVT');

854: where id = p_cplv_rec.chr_id;
855: begin
856:
857: IF (l_debug = 'Y') THEN
858: okc_debug.Set_Indentation('OKC_CPL_PVT');
859: okc_debug.log('2000: Entered validate_chr_id', 2);
860: END IF;
861:
862: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 979: okc_debug.Set_Indentation('OKC_CPL_PVT');

975: --Bug#3101222 */
976: begin
977:
978: IF (l_debug = 'Y') THEN
979: okc_debug.Set_Indentation('OKC_CPL_PVT');
980: okc_debug.log('2300: Entered validate_rle_code', 2);
981: END IF;
982:
983: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1109: okc_debug.Set_Indentation('OKC_CPL_PVT');

1105: p_cplv_rec IN CPLV_REC_TYPE) is
1106: begin
1107:
1108: IF (l_debug = 'Y') THEN
1109: okc_debug.Set_Indentation('OKC_CPL_PVT');
1110: okc_debug.log('2700: Entered validate_small_business_flag', 2);
1111: END IF;
1112:
1113: if (P_CPLV_REC.small_business_flag in ('Y','N',OKC_API.G_MISS_CHAR)

Line 1141: okc_debug.Set_Indentation('OKC_CPL_PVT');

1137: p_cplv_rec IN CPLV_REC_TYPE) is
1138: begin
1139:
1140: IF (l_debug = 'Y') THEN
1141: okc_debug.Set_Indentation('OKC_CPL_PVT');
1142: okc_debug.log('2800: Entered validate_women_owned_flag', 2);
1143: END IF;
1144:
1145: if (P_CPLV_REC.women_owned_flag in ('Y','N',OKC_API.G_MISS_CHAR)

Line 1190: okc_debug.Set_Indentation('OKC_CPL_PVT');

1186: ;
1187: begin
1188:
1189: IF (l_debug = 'Y') THEN
1190: okc_debug.Set_Indentation('OKC_CPL_PVT');
1191: okc_debug.log('2900: Entered validate_JTOT_OBJECT1_CODE', 2);
1192: END IF;
1193:
1194: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1275: okc_debug.Set_Indentation('OKC_CPL_PVT');

1271:
1272: begin
1273:
1274: IF (l_debug = 'Y') THEN
1275: okc_debug.Set_Indentation('OKC_CPL_PVT');
1276: okc_debug.log('3200: Entered validate_object1_id1', 2);
1277: END IF;
1278:
1279: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1395: okc_debug.Set_Indentation('OKC_CPL_PVT');

1391: where id = p_cplv_rec.dnz_chr_id;
1392: begin
1393:
1394: IF (l_debug = 'Y') THEN
1395: okc_debug.Set_Indentation('OKC_CPL_PVT');
1396: okc_debug.log('4000: Entered validate_dnz_chr_id', 2);
1397: END IF;
1398:
1399: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1477: okc_debug.Set_Indentation('OKC_CPL_PVT');

1473:
1474:
1475: Begin
1476: IF (l_debug = 'Y') THEN
1477: okc_debug.Set_Indentation('OKC_CPL_PVT');
1478: okc_debug.log('4150: Entered validate_primary_yn', 2);
1479: END IF;
1480:
1481: -- initialize return status

Line 1558: okc_debug.Set_Indentation('OKC_CPL_PVT');

1554: /*-------------Commented in favor of hand code------
1555: BEGIN
1556:
1557: IF (l_debug = 'Y') THEN
1558: okc_debug.Set_Indentation('OKC_CPL_PVT');
1559: okc_debug.log('4300: Entered Validate_Attributes', 2);
1560: END IF;
1561:
1562: IF p_cplv_rec.id = OKC_API.G_MISS_NUM OR

Line 1763: okc_debug.Set_Indentation('OKC_CPL_PVT');

1759: l_row_found Boolean := False;
1760: --+UK
1761: BEGIN
1762: IF (l_debug = 'Y') THEN
1763: okc_debug.Set_Indentation('OKC_CPL_PVT');
1764: okc_debug.log('5000: Entered Validate_Record', 2);
1765: END IF;
1766: if (p_cplv_rec.chr_id IS NULL and p_cplv_rec.cle_id IS NULL) then
1767: OKC_API.set_message(g_app_name,g_required_value,g_col_name_token,'CHR_ID, CLE_ID');

Line 2065: okc_debug.Set_Indentation('OKC_CPL_PVT');

2061: l_okc_k_party_roles_tl_rec okc_k_party_roles_tl_rec_type;
2062: BEGIN
2063:
2064: IF (l_debug = 'Y') THEN
2065: okc_debug.Set_Indentation('OKC_CPL_PVT');
2066: okc_debug.log('5200: Entered validate_row', 2);
2067: END IF;
2068:
2069: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2171: okc_debug.Set_Indentation('OKC_CPL_PVT');

2167: i NUMBER := 0;
2168: BEGIN
2169:
2170: IF (l_debug = 'Y') THEN
2171: okc_debug.Set_Indentation('OKC_CPL_PVT');
2172: okc_debug.log('5700: Entered validate_row', 2);
2173: END IF;
2174:
2175: OKC_API.init_msg_list(p_init_msg_list);

Line 2307: okc_debug.Set_Indentation('OKC_CPL_PVT');

2303: END Set_Attributes;
2304: BEGIN
2305:
2306: IF (l_debug = 'Y') THEN
2307: okc_debug.Set_Indentation('OKC_CPL_PVT');
2308: okc_debug.log('6300: Entered insert_row', 2);
2309: END IF;
2310:
2311: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2521: okc_debug.Set_Indentation('OKC_CPL_PVT');

2517: END Set_Attributes;
2518: BEGIN
2519:
2520: IF (l_debug = 'Y') THEN
2521: okc_debug.Set_Indentation('OKC_CPL_PVT');
2522: okc_debug.log('6900: Entered insert_row', 2);
2523: END IF;
2524:
2525: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2690: okc_debug.Set_Indentation('OKC_CPL_PVT');

2686: END Set_Attributes;
2687: BEGIN
2688:
2689: IF (l_debug = 'Y') THEN
2690: okc_debug.Set_Indentation('OKC_CPL_PVT');
2691: okc_debug.log('7600: Entered insert_row', 2);
2692: END IF;
2693:
2694: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2849: okc_debug.Set_Indentation('OKC_CPL_PVT');

2845: i NUMBER := 0;
2846: BEGIN
2847:
2848: IF (l_debug = 'Y') THEN
2849: okc_debug.Set_Indentation('OKC_CPL_PVT');
2850: okc_debug.log('8100: Entered insert_row', 2);
2851: END IF;
2852:
2853: OKC_API.init_msg_list(p_init_msg_list);

Line 2964: okc_debug.Set_Indentation('OKC_CPL_PVT');

2960: lc_row_notfound BOOLEAN := FALSE;
2961: BEGIN
2962:
2963: IF (l_debug = 'Y') THEN
2964: okc_debug.Set_Indentation('OKC_CPL_PVT');
2965: okc_debug.log('8600: Entered lock_row', 2);
2966: END IF;
2967:
2968: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2980: okc_debug.Set_Indentation('OKC_CPL_PVT');

2976: END IF;
2977: BEGIN
2978:
2979: IF (l_debug = 'Y') THEN
2980: okc_debug.Set_Indentation('OKC_CPL_PVT');
2981: okc_debug.log('8700: Entered lock_row', 2);
2982: END IF;
2983:
2984: OPEN lock_csr(p_cpl_rec);

Line 3113: okc_debug.Set_Indentation('OKC_CPL_PVT');

3109: lc_row_notfound BOOLEAN := FALSE;
3110: BEGIN
3111:
3112: IF (l_debug = 'Y') THEN
3113: okc_debug.Set_Indentation('OKC_CPL_PVT');
3114: okc_debug.log('9400: Entered lock_row', 2);
3115: END IF;
3116:
3117: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3129: okc_debug.Set_Indentation('OKC_CPL_PVT');

3125: END IF;
3126: BEGIN
3127:
3128: IF (l_debug = 'Y') THEN
3129: okc_debug.Set_Indentation('OKC_CPL_PVT');
3130: okc_debug.log('9500: Entered lock_row', 2);
3131: END IF;
3132:
3133: OPEN lock_csr(p_okc_k_party_roles_tl_rec);

Line 3239: okc_debug.Set_Indentation('OKC_CPL_PVT');

3235: l_okc_k_party_roles_tl_rec okc_k_party_roles_tl_rec_type;
3236: BEGIN
3237:
3238: IF (l_debug = 'Y') THEN
3239: okc_debug.Set_Indentation('OKC_CPL_PVT');
3240: okc_debug.log('10200: Entered lock_row', 2);
3241: END IF;
3242:
3243: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3363: okc_debug.Set_Indentation('OKC_CPL_PVT');

3359: i NUMBER := 0;
3360: BEGIN
3361:
3362: IF (l_debug = 'Y') THEN
3363: okc_debug.Set_Indentation('OKC_CPL_PVT');
3364: okc_debug.log('10700: Entered lock_row', 2);
3365: END IF;
3366:
3367: OKC_API.init_msg_list(p_init_msg_list);

Line 3474: okc_debug.Set_Indentation('OKC_CPL_PVT');

3470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3471: BEGIN
3472:
3473: IF (l_debug = 'Y') THEN
3474: okc_debug.Set_Indentation('OKC_CPL_PVT');
3475: okc_debug.log('11200: Entered populate_new_record', 2);
3476: END IF;
3477:
3478: x_cpl_rec := p_cpl_rec;

Line 3682: okc_debug.Set_Indentation('OKC_CPL_PVT');

3678: -------------------------------------
3679: BEGIN
3680:
3681: IF (l_debug = 'Y') THEN
3682: okc_debug.Set_Indentation('OKC_CPL_PVT');
3683: okc_debug.log('11400: Entered update_row', 2);
3684: END IF;
3685:
3686: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 3845: okc_debug.Set_Indentation('OKC_CPL_PVT');

3841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3842: BEGIN
3843:
3844: IF (l_debug = 'Y') THEN
3845: okc_debug.Set_Indentation('OKC_CPL_PVT');
3846: okc_debug.log('11900: Entered populate_new_record', 2);
3847: END IF;
3848:
3849: x_okc_k_party_roles_tl_rec := p_okc_k_party_roles_tl_rec;

Line 3928: okc_debug.Set_Indentation('OKC_CPL_PVT');

3924: END Set_Attributes;
3925: BEGIN
3926:
3927: IF (l_debug = 'Y') THEN
3928: okc_debug.Set_Indentation('OKC_CPL_PVT');
3929: okc_debug.log('12100: Entered update_row', 2);
3930: END IF;
3931:
3932: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4087: okc_debug.Set_Indentation('OKC_CPL_PVT');

4083: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4084: BEGIN
4085:
4086: IF (l_debug = 'Y') THEN
4087: okc_debug.Set_Indentation('OKC_CPL_PVT');
4088: okc_debug.log('12700: Entered populate_new_record', 2);
4089: END IF;
4090:
4091: x_cplv_rec := p_cplv_rec;

Line 4292: okc_debug.Set_Indentation('OKC_CPL_PVT');

4288: END Set_Attributes;
4289: BEGIN
4290:
4291: IF (l_debug = 'Y') THEN
4292: okc_debug.Set_Indentation('OKC_CPL_PVT');
4293: okc_debug.log('12900: Entered update_row', 2);
4294: END IF;
4295:
4296: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4454: okc_debug.Set_Indentation('OKC_CPL_PVT');

4450: i NUMBER := 0;
4451: BEGIN
4452:
4453: IF (l_debug = 'Y') THEN
4454: okc_debug.Set_Indentation('OKC_CPL_PVT');
4455: okc_debug.log('13400: Entered update_row', 2);
4456: END IF;
4457:
4458: OKC_API.init_msg_list(p_init_msg_list);

Line 4554: okc_debug.Set_Indentation('OKC_CPL_PVT');

4550: l_row_notfound BOOLEAN := TRUE;
4551: BEGIN
4552:
4553: IF (l_debug = 'Y') THEN
4554: okc_debug.Set_Indentation('OKC_CPL_PVT');
4555: okc_debug.log('13900: Entered delete_row', 2);
4556: END IF;
4557:
4558: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4662: okc_debug.Set_Indentation('OKC_CPL_PVT');

4658: END Set_Attributes;
4659: BEGIN
4660:
4661: IF (l_debug = 'Y') THEN
4662: okc_debug.Set_Indentation('OKC_CPL_PVT');
4663: okc_debug.log('14500: Entered delete_row', 2);
4664: END IF;
4665:
4666: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4766: okc_debug.Set_Indentation('OKC_CPL_PVT');

4762: l_cpl_rec cpl_rec_type;
4763: BEGIN
4764:
4765: IF (l_debug = 'Y') THEN
4766: okc_debug.Set_Indentation('OKC_CPL_PVT');
4767: okc_debug.log('15000: Entered delete_row', 2);
4768: END IF;
4769:
4770: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 4890: okc_debug.Set_Indentation('OKC_CPL_PVT');

4886: i NUMBER := 0;
4887: BEGIN
4888:
4889: IF (l_debug = 'Y') THEN
4890: okc_debug.Set_Indentation('OKC_CPL_PVT');
4891: okc_debug.log('15500: Entered delete_row', 2);
4892: END IF;
4893:
4894: OKC_API.init_msg_list(p_init_msg_list);

Line 5024: okc_debug.Set_Indentation('OKC_CPL_PVT');

5020:
5021: -- Initializing return status
5022: x_return_status := OKC_API.G_RET_STS_SUCCESS;
5023: IF (l_debug = 'Y') THEN
5024: okc_debug.Set_Indentation('OKC_CPL_PVT');
5025: okc_debug.log('16000: Entered INSERT_ROW_UPG', 2);
5026: END IF;
5027:
5028: i := p_cplv_tbl.FIRST; j:=0;

Line 5239: okc_debug.Set_Indentation('OKC_CPL_PVT');

5235:
5236: BEGIN
5237:
5238: IF (l_debug = 'Y') THEN
5239: okc_debug.Set_Indentation('OKC_CPL_PVT');
5240: okc_debug.log('16300: Entered create_version', 2);
5241: END IF;
5242:
5243: INSERT INTO okc_k_party_roles_bh

Line 5422: okc_debug.Set_Indentation('OKC_CPL_PVT');

5418:
5419: BEGIN
5420:
5421: IF (l_debug = 'Y') THEN
5422: okc_debug.Set_Indentation('OKC_CPL_PVT');
5423: okc_debug.log('16600: Entered restore_version', 2);
5424: END IF;
5425:
5426: INSERT INTO okc_k_party_roles_tl

Line 5588: END OKC_CPL_PVT;

5584: return l_return_status;
5585:
5586: END restore_version;
5587:
5588: END OKC_CPL_PVT;