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.OKS_SETUP_UTIL_PUB dependencies on OKS_RENEW_PVT

Line 26: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

22: p_encoded => 'F',
23: p_data => l_msg_data,
24: p_msg_index_out => l_msg_index
25: );
26: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
27: p_perf_msg =>l_msg_data);
28:
29: End loop;
30:

Line 692: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

688: l_klnv_tbl(ctr).break_uom := null;
689: ----------------------------------
690: -- Copies the lock in case of copy
691: If p_do_copy and get_lines_attr_rec.LOCKED_PRICE_LIST_ID is not null Then
692: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
693: p_perf_msg =>'do copy is true');
694: Open get_contract_number(p_new_chr_id);
695: Fetch get_contract_number into l_contract_number;
696: Close get_contract_number;

Line 697: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

693: p_perf_msg =>'do copy is true');
694: Open get_contract_number(p_new_chr_id);
695: Fetch get_contract_number into l_contract_number;
696: Close get_contract_number;
697: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
698: p_perf_msg =>'get_lines_attr_rec.LOCKED_PRICE_LIST_LINE_ID: ' || get_lines_attr_rec.LOCKED_PRICE_LIST_LINE_ID);
699:
700: -- MKS Commented out.. Need to put back in once QP patch is ready.
701: /*

Line 1810: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

1806: l_date_terminated date;
1807:
1808: BEGIN
1809:
1810: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1811: p_perf_msg =>'Inside get_strlvls procedure ');
1812:
1813: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1814:

Line 1874: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

1870: END LOOP;
1871:
1872: x_strlvl_tbl := l_strlvl_tbl;
1873:
1874: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1875: p_perf_msg =>'Building Stream Levels Successful ');
1876:
1877: For get_ccr_rec In get_ccr(p_cle_id)
1878: Loop

Line 1903: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

1899: p_validate_yn => 'N');
1900: END IF;
1901: End Loop; --For get_line_id_rec In get_line_id_csr
1902:
1903: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1904: p_perf_msg =>'After Update CCR Rule ');
1905:
1906: x_return_status := l_return_status;
1907:

Line 2009: OKS_RENEW_PVT.Debug_Log

2005: p_new_chr_id => sub_line_grp_rec.dnz_chr_id,
2006: p_do_copy => p_do_copy,
2007: x_return_status => l_return_status);
2008:
2009: OKS_RENEW_PVT.Debug_Log
2010: (p_program_name => 'OKSCOPY'
2011: ,p_perf_msg =>'SubLine copy_lines_attr Status '||l_return_status);
2012:
2013: IF (l_return_status = 'S' AND p_upd_line_flag IS NULL) THEN

Line 2022: OKS_RENEW_PVT.Debug_Log

2018: x_return_status => l_return_status);
2019:
2020: END IF;
2021:
2022: OKS_RENEW_PVT.Debug_Log
2023: (p_program_name => 'OKSCOPY'
2024: ,p_perf_msg =>'SubLine copy_revenue_distb Status'||l_return_status);
2025: x_return_status := l_return_status;
2026:

Line 2057: OKS_RENEW_PVT.Debug_Log

2053: x_return_status =>l_return_status);
2054:
2055:
2056:
2057: OKS_RENEW_PVT.Debug_Log
2058: (p_program_name => 'OKSCOPY'
2059: ,p_perf_msg =>'P SubLine Billing Schedule Creation Status '||l_return_status);
2060:
2061: END IF; --l_return_status = 'S'

Line 2099: OKS_RENEW_PVT.Debug_Log

2095:
2096: --Calls API for level element creation
2097: --This take care covered level of 'E' and 'T as well
2098:
2099: OKS_RENEW_PVT.Debug_Log
2100: (p_program_name => 'OKSCOPY',
2101: p_perf_msg =>'Before Creating Billing Schedule');
2102:
2103:

Line 2120: OKS_RENEW_PVT.Debug_Log

2116: END IF;--l_SLL_tbl_type.COUNT > 0
2117:
2118: -- END IF;
2119:
2120: OKS_RENEW_PVT.Debug_Log
2121: (p_program_name => 'OKSCOPY'
2122: ,p_perf_msg =>'Billing Schedule Creation Status '||l_return_status);
2123:
2124: END IF;

Line 2239: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',

2235: l_old_chr_id := l_chr_renew_rec.orig_system_id1;
2236: -- Added for bug # 4066428
2237: If l_old_chr_id is null Then
2238: x_return_status := l_return_status;
2239: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',
2240: p_perf_msg => 'Exiting chk_hdr_effectivity because orig_system_id1 was null');
2241: return;
2242: End If;
2243: -- End of add for bug # 4066428

Line 2244: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',

2240: p_perf_msg => 'Exiting chk_hdr_effectivity because orig_system_id1 was null');
2241: return;
2242: End If;
2243: -- End of add for bug # 4066428
2244: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',
2245: p_perf_msg => 'l_old_chr_id ' || l_old_chr_id);
2246:
2247:
2248: OPEN l_chr_old_csr(l_old_chr_id);

Line 2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old start date ' || l_chr_old_rec.start_date);

2248: OPEN l_chr_old_csr(l_old_chr_id);
2249: FETCH l_chr_old_csr INTO l_chr_old_rec;
2250: CLOSE l_chr_old_csr;
2251:
2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old start date ' || l_chr_old_rec.start_date);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old end date ' || l_chr_old_rec.end_date);
2254: OKC_TIME_UTIL_PUB.get_duration(
2255: l_chr_old_rec.start_date
2256: ,l_chr_old_rec.end_date

Line 2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old end date ' || l_chr_old_rec.end_date);

2249: FETCH l_chr_old_csr INTO l_chr_old_rec;
2250: CLOSE l_chr_old_csr;
2251:
2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old start date ' || l_chr_old_rec.start_date);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old end date ' || l_chr_old_rec.end_date);
2254: OKC_TIME_UTIL_PUB.get_duration(
2255: l_chr_old_rec.start_date
2256: ,l_chr_old_rec.end_date
2257: ,l_old_duration

Line 2261: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);

2257: ,l_old_duration
2258: ,l_old_time
2259: ,l_return_status
2260: );
2261: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2264: IF l_return_status = 'S' Then
2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);

Line 2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);

2258: ,l_old_time
2259: ,l_return_status
2260: );
2261: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2264: IF l_return_status = 'S' Then
2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);

Line 2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);

2259: ,l_return_status
2260: );
2261: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2264: IF l_return_status = 'S' Then
2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2267:

Line 2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);

2261: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2264: IF l_return_status = 'S' Then
2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2267:
2268: OKC_TIME_UTIL_PUB.get_duration(
2269: l_chr_renew_rec.start_date

Line 2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);

2262: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2263: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2264: IF l_return_status = 'S' Then
2265: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2267:
2268: OKC_TIME_UTIL_PUB.get_duration(
2269: l_chr_renew_rec.start_date
2270: ,l_chr_renew_rec.end_date

Line 2275: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);

2271: ,l_renew_duration
2272: ,l_renew_time
2273: ,l_return_status
2274: );
2275: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2276: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2277: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2278:
2279: IF l_return_status = 'S'

Line 2276: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);

2272: ,l_renew_time
2273: ,l_return_status
2274: );
2275: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2276: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2277: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2278:
2279: IF l_return_status = 'S'
2280: THEN

Line 2277: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);

2273: ,l_return_status
2274: );
2275: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2276: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2277: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2278:
2279: IF l_return_status = 'S'
2280: THEN
2281: IF ((l_old_duration <> l_renew_duration) OR

Line 2748: OKS_RENEW_PVT.Debug_Log

2744:
2745: --begin Okscopy procedure
2746: BEGIN
2747:
2748: OKS_RENEW_PVT.Debug_Log
2749: (p_program_name => 'OKSCOPY'
2750: ,p_perf_msg =>'OKSCOPY: start time= '||to_char(sysdate,'HH:MI:SS'));
2751: -- initialize return status
2752: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2768: OKS_RENEW_PVT.Debug_Log

2764: Fetch got_renewed into l_oldchr_id;
2765: If got_renewed%NOTFOUND Then
2766: l_duration_match := 'T'; -- The contract is being copied therefore the duration matches.
2767: l_do_copy := true;
2768: OKS_RENEW_PVT.Debug_Log
2769: (p_program_name => 'OKSCOPY'
2770: ,p_perf_msg =>'copy is true= '||to_char(sysdate,'HH:MI:SS'));
2771: Else
2772: -- Check if any line belongs to another contract then it's

Line 2779: OKS_RENEW_PVT.Debug_Log

2775: Fetch is_line_copy into l_line_id;
2776: If is_line_copy%FOUND Then
2777: l_duration_match := 'T'; -- The contract is being copied therefore the duration matches.
2778: l_do_copy := true;
2779: OKS_RENEW_PVT.Debug_Log
2780: (p_program_name => 'OKSCOPY'
2781: ,p_perf_msg =>'copy is true2= '||to_char(sysdate,'HH:MI:SS'));
2782: Else
2783: l_duration_match := 'F';

Line 2785: OKS_RENEW_PVT.Debug_Log

2781: ,p_perf_msg =>'copy is true2= '||to_char(sysdate,'HH:MI:SS'));
2782: Else
2783: l_duration_match := 'F';
2784: l_do_copy := false;
2785: OKS_RENEW_PVT.Debug_Log
2786: (p_program_name => 'OKSCOPY'
2787: ,p_perf_msg =>'copy is false 1= '||to_char(sysdate,'HH:MI:SS'));
2788: End If;
2789: Close is_line_copy;

Line 2795: OKS_RENEW_PVT.Debug_Log

2791: Close got_renewed;
2792: Else
2793: l_do_copy := false;
2794: l_second_call := true;
2795: OKS_RENEW_PVT.Debug_Log
2796: (p_program_name => 'OKSCOPY'
2797: ,p_perf_msg =>'copy is false2 = '||to_char(sysdate,'HH:MI:SS'));
2798: chk_hdr_effectivity(
2799: p_chr_id,

Line 2932: OKS_RENEW_PVT.Debug_Log

2928: G_SQLERRM_TOKEN,
2929: 'Error in update_contract_header');
2930: RAISE G_EXCEPTION_HALT_VALIDATION;
2931: End If;
2932: OKS_RENEW_PVT.Debug_Log
2933: (p_program_name => 'OKSCOPY'
2934: ,p_perf_msg =>'Went into QA hold: start time= '||to_char(sysdate,'HH:MI:SS'));
2935: End If;
2936:

Line 2969: OKS_RENEW_PVT.Debug_Log

2965: RAISE G_EXCEPTION_HALT_VALIDATION;
2966: END IF;
2967:
2968:
2969: OKS_RENEW_PVT.Debug_Log
2970: (p_program_name => 'OKSCOPY'
2971: ,p_perf_msg =>'Copy Header Attribute status '||l_return_status);
2972:
2973: x_return_status := l_return_status;

Line 2987: OKS_RENEW_PVT.Debug_Log

2983: x_return_status => l_return_status,
2984: x_msg_count => l_msg_count,
2985: x_msg_data => l_msg_data);
2986:
2987: OKS_RENEW_PVT.Debug_Log
2988: (p_program_name => 'OKSCOPY'
2989: ,p_perf_msg =>'COPY_K_HDR_NOTES '||l_return_status);
2990:
2991: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3011: OKS_RENEW_PVT.Debug_Log

3007: x_return_status => l_return_status);
3008:
3009: x_return_status := l_return_status;
3010:
3011: OKS_RENEW_PVT.Debug_Log
3012: (p_program_name => 'OKSCOPY'
3013: ,p_perf_msg =>'copy Hedader salescredit Status '||l_return_status);
3014:
3015: END IF; --l_return_status = 'S'

Line 3029: OKS_RENEW_PVT.Debug_Log

3025: Copy_Hdr_Bill_Sch( p_chr_id => l_old_chr_id,
3026: p_new_chr_id => p_chr_id,
3027: x_return_status => l_return_status);
3028:
3029: OKS_RENEW_PVT.Debug_Log
3030: (p_program_name => 'OKSCOPY'
3031: ,p_perf_msg =>'copy Hedader Billing Schedule Status '||l_return_status);
3032: END IF;
3033: END IF;

Line 3089: OKS_RENEW_PVT.Debug_Log

3085: p_invoice_rule_id => l_inv_rule_id,
3086: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
3087: x_return_status => l_return_status);
3088:
3089: OKS_RENEW_PVT.Debug_Log
3090: (p_program_name => 'OKSCOPY'
3091: ,p_perf_msg =>'copy Lines Billing Schedule Status '||l_return_status);
3092: END IF; --l_sll_count=0
3093: END IF; --l_duration_match = 'T'

Line 3110: OKS_RENEW_PVT.Debug_Log

3106: x_msg_count => l_msg_count ,
3107: x_msg_data => l_msg_data ,
3108: p_contract_line_id => check_top_line_exist_rec.id );
3109:
3110: OKS_RENEW_PVT.Debug_Log
3111: (p_program_name => 'OKSCOPY'
3112: ,p_perf_msg =>'Copy Coverage Status '||l_return_status);
3113:
3114: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3143: OKS_RENEW_PVT.Debug_Log

3139: x_return_status => l_return_status);
3140:
3141: END IF;
3142:
3143: OKS_RENEW_PVT.Debug_Log
3144: (p_program_name => 'OKSCOPY'
3145: ,p_perf_msg =>'copy Lines Attr Status '||l_return_status);
3146:
3147: --check item exists

Line 3186: OKS_RENEW_PVT.Debug_Log

3182: p_cle_id => check_top_line_exist_rec.id,
3183: x_return_status => l_return_status);
3184: x_return_status := l_return_status;
3185:
3186: OKS_RENEW_PVT.Debug_Log
3187: (p_program_name => 'OKSCOPY'
3188: ,p_perf_msg =>'check CCR Rule Status '||l_return_status);
3189:
3190: END IF; --l_return_status = 'S'

Line 3202: OKS_RENEW_PVT.Debug_Log

3198: p_new_chr_id => check_top_line_exist_rec.dnz_chr_id,
3199: x_return_status => l_return_status);
3200: x_return_status := l_return_status;
3201:
3202: OKS_RENEW_PVT.Debug_Log
3203: (p_program_name => 'OKSCOPY'
3204: ,p_perf_msg =>'Copy Lines revenue dist Status '||l_return_status);
3205: END IF; --l_return_status = 'S'
3206:

Line 3218: OKS_RENEW_PVT.Debug_Log

3214: x_return_status => l_return_status);
3215:
3216: x_return_status := l_return_status;
3217:
3218: OKS_RENEW_PVT.Debug_Log
3219: (p_program_name => 'OKSCOPY'
3220: ,p_perf_msg =>'Copy Line Sales Credit Status '||l_return_status);
3221:
3222: END IF; --l_return_status = 'S'

Line 3237: OKS_RENEW_PVT.Debug_Log

3233: x_msg_count => l_msg_count ,
3234: x_msg_data => l_msg_data ,
3235: p_contract_line_id => check_top_line_exist_rec.id );
3236:
3237: OKS_RENEW_PVT.Debug_Log
3238: (p_program_name => 'OKSCOPY'
3239: ,p_perf_msg =>'Copy Coverage Status '||l_return_status);
3240:
3241: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3255: OKS_RENEW_PVT.Debug_Log

3251: ,check_top_line_exist_rec.id
3252: ,null
3253: ,l_return_status);
3254:
3255: OKS_RENEW_PVT.Debug_Log
3256: (p_program_name => 'OKSCOPY'
3257: ,p_perf_msg =>'Copy subscr_inst Status '||l_return_status);
3258:
3259: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3298: OKS_RENEW_PVT.Debug_Log

3294: p_new_cle_id => cle_grp_rec.id,
3295: p_new_chr_id => cle_grp_rec.dnz_chr_id,
3296: x_return_status => l_return_status);
3297:
3298: OKS_RENEW_PVT.Debug_Log
3299: (p_program_name => 'OKSCOPY'
3300: ,p_perf_msg =>'Line Copy line_attr Status'||l_return_status);
3301:
3302: END IF;

Line 3325: OKS_RENEW_PVT.Debug_Log

3321: p_new_chr_id => cle_grp_rec.dnz_chr_id,
3322: x_return_status => l_return_status);
3323:
3324: x_return_status := l_return_status;
3325: OKS_RENEW_PVT.Debug_Log
3326: (p_program_name => 'OKSCOPY'
3327: ,p_perf_msg =>'Line Copy line_revenue_dist Status'||l_return_status);
3328: END IF; --l_return_status = 'S'
3329:

Line 3341: OKS_RENEW_PVT.Debug_Log

3337: x_return_status => l_return_status);
3338:
3339: x_return_status := l_return_status;
3340:
3341: OKS_RENEW_PVT.Debug_Log
3342: (p_program_name => 'OKSCOPY'
3343: ,p_perf_msg =>'Line Copy line_sales_credit Status'||l_return_status);
3344:
3345: END IF; --l_return_status = 'S'

Line 3353: OKS_RENEW_PVT.Debug_Log

3349: p_cle_id => cle_grp_rec.id,
3350: x_return_status => l_return_status);
3351: x_return_status := l_return_status;
3352:
3353: OKS_RENEW_PVT.Debug_Log
3354: (p_program_name => 'OKSCOPY'
3355: ,p_perf_msg =>'check CCR Rule Status'||l_return_status);
3356:
3357: END IF; --l_return_status = 'S'

Line 3365: OKS_RENEW_PVT.Debug_Log

3361: ,cle_grp_rec.id
3362: ,null
3363: ,l_return_status);
3364:
3365: OKS_RENEW_PVT.Debug_Log
3366: (p_program_name => 'OKSCOPY'
3367: ,p_perf_msg =>'Line Copy line_subscr_inst Status'||l_return_status);
3368: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3369: x_return_status := l_return_status;

Line 3386: OKS_RENEW_PVT.Debug_Log

3382: x_msg_count => l_msg_count ,
3383: x_msg_data => l_msg_data ,
3384: p_contract_line_id => cle_grp_rec.id );
3385:
3386: OKS_RENEW_PVT.Debug_Log
3387: (p_program_name => 'OKSCOPY'
3388: ,p_perf_msg =>'Copy Coverage Status'||l_return_status);
3389:
3390: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3464: OKS_RENEW_PVT.Debug_Log

3460: update_line_numbers (p_chr_id => p_chr_id
3461: ,p_update_top_line => l_update_top_line
3462: ,x_return_status => l_return_status);
3463:
3464: OKS_RENEW_PVT.Debug_Log
3465: (p_program_name => 'OKSCOPY'
3466: ,p_perf_msg =>'Update Line Number Status'||l_return_status);
3467:
3468: x_return_status := l_return_status;

Line 3485: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3481: Close get_price_list;
3482: -- For renewal the price lock doesnt get copied in the first
3483: -- okscopy call. It gets copied in the second call only
3484: -- if the price list ids are the same.
3485: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3486: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3487: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3488: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3489: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

Line 3487: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3483: -- okscopy call. It gets copied in the second call only
3484: -- if the price list ids are the same.
3485: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3486: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3487: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3488: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3489: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3490: p_perf_msg =>'new contract lse id: ' || get_lines_rec.lse_id);
3491: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then

Line 3489: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3485: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3486: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3487: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3488: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3489: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3490: p_perf_msg =>'new contract lse id: ' || get_lines_rec.lse_id);
3491: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then
3492: Open get_contract_number(p_chr_id);
3493: Fetch get_contract_number into l_contract_number;

Line 3495: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3491: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then
3492: Open get_contract_number(p_chr_id);
3493: Fetch get_contract_number into l_contract_number;
3494: Close get_contract_number;
3495: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3496: p_perf_msg =>'Calling QP API');
3497: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3498: p_perf_msg =>' get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID: ' || get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID);
3499: -- MKS Commented out.. Need to put back in once QP patch is ready.

Line 3497: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3493: Fetch get_contract_number into l_contract_number;
3494: Close get_contract_number;
3495: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3496: p_perf_msg =>'Calling QP API');
3497: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3498: p_perf_msg =>' get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID: ' || get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID);
3499: -- MKS Commented out.. Need to put back in once QP patch is ready.
3500: /*
3501: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID,

Line 3511: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3507: x_msg_count => l_msg_count,
3508: x_msg_data => l_msg_data);
3509:
3510: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
3511: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3512: p_perf_msg =>'QP failed.');
3513: RAISE G_EXCEPTION_HALT_VALIDATION;
3514: END IF;
3515: */

Line 3520: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3516: select id
3517: into l_oks_line_id
3518: from oks_k_lines_b where cle_id = get_lines_rec.id;
3519:
3520: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3521: p_perf_msg =>'After cursor call');
3522: Update oks_k_lines_b set
3523: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3524: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,

Line 3527: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

3523: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3524: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,
3525: break_uom = get_oks_line_attr.break_uom
3526: where id = l_oks_line_id;
3527: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3528: p_perf_msg =>'After update');
3529:
3530: End If; -- if price list ids are different
3531: End If; -- if original contract has a price list id

Line 3537: OKS_RENEW_PVT.Debug_Log

3533: End Loop; -- loop through new contracts
3534: End If; -- if being called in renew the second time
3535:
3536:
3537: OKS_RENEW_PVT.Debug_Log
3538: (p_program_name => 'OKSCOPY'
3539: ,p_perf_msg =>'OKSCOPY: end time= '||to_char(sysdate,'HH:MI:SS'));
3540:
3541: x_return_status := l_return_status;