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 687: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

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

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

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

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

1797: l_date_terminated date;
1798:
1799: BEGIN
1800:
1801: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1802: p_perf_msg =>'Inside get_strlvls procedure ');
1803:
1804: l_return_status := OKC_API.G_RET_STS_SUCCESS;
1805:

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

1861: END LOOP;
1862:
1863: x_strlvl_tbl := l_strlvl_tbl;
1864:
1865: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1866: p_perf_msg =>'Building Stream Levels Successful ');
1867:
1868: For get_ccr_rec In get_ccr(p_cle_id)
1869: Loop

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

1890: p_validate_yn => 'N');
1891: END IF;
1892: End Loop; --For get_line_id_rec In get_line_id_csr
1893:
1894: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
1895: p_perf_msg =>'After Update CCR Rule ');
1896:
1897: x_return_status := l_return_status;
1898:

Line 2000: OKS_RENEW_PVT.Debug_Log

1996: p_new_chr_id => sub_line_grp_rec.dnz_chr_id,
1997: p_do_copy => p_do_copy,
1998: x_return_status => l_return_status);
1999:
2000: OKS_RENEW_PVT.Debug_Log
2001: (p_program_name => 'OKSCOPY'
2002: ,p_perf_msg =>'SubLine copy_lines_attr Status '||l_return_status);
2003:
2004: IF (l_return_status = 'S' AND p_upd_line_flag IS NULL) THEN

Line 2013: OKS_RENEW_PVT.Debug_Log

2009: x_return_status => l_return_status);
2010:
2011: END IF;
2012:
2013: OKS_RENEW_PVT.Debug_Log
2014: (p_program_name => 'OKSCOPY'
2015: ,p_perf_msg =>'SubLine copy_revenue_distb Status'||l_return_status);
2016: x_return_status := l_return_status;
2017:

Line 2048: OKS_RENEW_PVT.Debug_Log

2044: x_return_status =>l_return_status);
2045:
2046:
2047:
2048: OKS_RENEW_PVT.Debug_Log
2049: (p_program_name => 'OKSCOPY'
2050: ,p_perf_msg =>'P SubLine Billing Schedule Creation Status '||l_return_status);
2051:
2052: END IF; --l_return_status = 'S'

Line 2090: OKS_RENEW_PVT.Debug_Log

2086:
2087: --Calls API for level element creation
2088: --This take care covered level of 'E' and 'T as well
2089:
2090: OKS_RENEW_PVT.Debug_Log
2091: (p_program_name => 'OKSCOPY',
2092: p_perf_msg =>'Before Creating Billing Schedule');
2093:
2094:

Line 2111: OKS_RENEW_PVT.Debug_Log

2107: END IF;--l_SLL_tbl_type.COUNT > 0
2108:
2109: -- END IF;
2110:
2111: OKS_RENEW_PVT.Debug_Log
2112: (p_program_name => 'OKSCOPY'
2113: ,p_perf_msg =>'Billing Schedule Creation Status '||l_return_status);
2114:
2115: END IF;

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

2226: l_old_chr_id := l_chr_renew_rec.orig_system_id1;
2227: -- Added for bug # 4066428
2228: If l_old_chr_id is null Then
2229: x_return_status := l_return_status;
2230: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',
2231: p_perf_msg => 'Exiting chk_hdr_effectivity because orig_system_id1 was null');
2232: return;
2233: End If;
2234: -- End of add for bug # 4066428

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

2231: p_perf_msg => 'Exiting chk_hdr_effectivity because orig_system_id1 was null');
2232: return;
2233: End If;
2234: -- End of add for bug # 4066428
2235: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',
2236: p_perf_msg => 'l_old_chr_id ' || l_old_chr_id);
2237:
2238:
2239: OPEN l_chr_old_csr(l_old_chr_id);

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

2239: OPEN l_chr_old_csr(l_old_chr_id);
2240: FETCH l_chr_old_csr INTO l_chr_old_rec;
2241: CLOSE l_chr_old_csr;
2242:
2243: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old start date ' || l_chr_old_rec.start_date);
2244: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old end date ' || l_chr_old_rec.end_date);
2245: OKC_TIME_UTIL_PUB.get_duration(
2246: l_chr_old_rec.start_date
2247: ,l_chr_old_rec.end_date

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

2240: FETCH l_chr_old_csr INTO l_chr_old_rec;
2241: CLOSE l_chr_old_csr;
2242:
2243: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old start date ' || l_chr_old_rec.start_date);
2244: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'old end date ' || l_chr_old_rec.end_date);
2245: OKC_TIME_UTIL_PUB.get_duration(
2246: l_chr_old_rec.start_date
2247: ,l_chr_old_rec.end_date
2248: ,l_old_duration

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

2248: ,l_old_duration
2249: ,l_old_time
2250: ,l_return_status
2251: );
2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2254: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2255: IF l_return_status = 'S' Then
2256: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);

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

2249: ,l_old_time
2250: ,l_return_status
2251: );
2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2254: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2255: IF l_return_status = 'S' Then
2256: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2257: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);

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

2250: ,l_return_status
2251: );
2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2254: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2255: IF l_return_status = 'S' Then
2256: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2257: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2258:

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

2252: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_duration ' || l_old_duration);
2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2254: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2255: IF l_return_status = 'S' Then
2256: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2257: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2258:
2259: OKC_TIME_UTIL_PUB.get_duration(
2260: l_chr_renew_rec.start_date

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

2253: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_old_time ' || l_old_time);
2254: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2255: IF l_return_status = 'S' Then
2256: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new start date ' || l_chr_renew_rec.start_date);
2257: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'new end date ' || l_chr_renew_rec.end_date);
2258:
2259: OKC_TIME_UTIL_PUB.get_duration(
2260: l_chr_renew_rec.start_date
2261: ,l_chr_renew_rec.end_date

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

2262: ,l_renew_duration
2263: ,l_renew_time
2264: ,l_return_status
2265: );
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2267: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2268: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2269:
2270: IF l_return_status = 'S'

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

2263: ,l_renew_time
2264: ,l_return_status
2265: );
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2267: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2268: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2269:
2270: IF l_return_status = 'S'
2271: THEN

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

2264: ,l_return_status
2265: );
2266: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_new_duration ' || l_renew_duration);
2267: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_renew_time ' || l_renew_time);
2268: oks_renew_pvt.Debug_Log(p_program_name => 'OKSCOPY',p_perf_msg => 'l_return_status ' || l_return_status);
2269:
2270: IF l_return_status = 'S'
2271: THEN
2272: IF ((l_old_duration <> l_renew_duration) OR

Line 2739: OKS_RENEW_PVT.Debug_Log

2735:
2736: --begin Okscopy procedure
2737: BEGIN
2738:
2739: OKS_RENEW_PVT.Debug_Log
2740: (p_program_name => 'OKSCOPY'
2741: ,p_perf_msg =>'OKSCOPY: start time= '||to_char(sysdate,'HH:MI:SS'));
2742: -- initialize return status
2743: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 2759: OKS_RENEW_PVT.Debug_Log

2755: Fetch got_renewed into l_oldchr_id;
2756: If got_renewed%NOTFOUND Then
2757: l_duration_match := 'T'; -- The contract is being copied therefore the duration matches.
2758: l_do_copy := true;
2759: OKS_RENEW_PVT.Debug_Log
2760: (p_program_name => 'OKSCOPY'
2761: ,p_perf_msg =>'copy is true= '||to_char(sysdate,'HH:MI:SS'));
2762: Else
2763: -- Check if any line belongs to another contract then it's

Line 2770: OKS_RENEW_PVT.Debug_Log

2766: Fetch is_line_copy into l_line_id;
2767: If is_line_copy%FOUND Then
2768: l_duration_match := 'T'; -- The contract is being copied therefore the duration matches.
2769: l_do_copy := true;
2770: OKS_RENEW_PVT.Debug_Log
2771: (p_program_name => 'OKSCOPY'
2772: ,p_perf_msg =>'copy is true2= '||to_char(sysdate,'HH:MI:SS'));
2773: Else
2774: l_duration_match := 'F';

Line 2776: OKS_RENEW_PVT.Debug_Log

2772: ,p_perf_msg =>'copy is true2= '||to_char(sysdate,'HH:MI:SS'));
2773: Else
2774: l_duration_match := 'F';
2775: l_do_copy := false;
2776: OKS_RENEW_PVT.Debug_Log
2777: (p_program_name => 'OKSCOPY'
2778: ,p_perf_msg =>'copy is false 1= '||to_char(sysdate,'HH:MI:SS'));
2779: End If;
2780: Close is_line_copy;

Line 2786: OKS_RENEW_PVT.Debug_Log

2782: Close got_renewed;
2783: Else
2784: l_do_copy := false;
2785: l_second_call := true;
2786: OKS_RENEW_PVT.Debug_Log
2787: (p_program_name => 'OKSCOPY'
2788: ,p_perf_msg =>'copy is false2 = '||to_char(sysdate,'HH:MI:SS'));
2789: chk_hdr_effectivity(
2790: p_chr_id,

Line 2923: OKS_RENEW_PVT.Debug_Log

2919: G_SQLERRM_TOKEN,
2920: 'Error in update_contract_header');
2921: RAISE G_EXCEPTION_HALT_VALIDATION;
2922: End If;
2923: OKS_RENEW_PVT.Debug_Log
2924: (p_program_name => 'OKSCOPY'
2925: ,p_perf_msg =>'Went into QA hold: start time= '||to_char(sysdate,'HH:MI:SS'));
2926: End If;
2927:

Line 2960: OKS_RENEW_PVT.Debug_Log

2956: RAISE G_EXCEPTION_HALT_VALIDATION;
2957: END IF;
2958:
2959:
2960: OKS_RENEW_PVT.Debug_Log
2961: (p_program_name => 'OKSCOPY'
2962: ,p_perf_msg =>'Copy Header Attribute status '||l_return_status);
2963:
2964: x_return_status := l_return_status;

Line 2978: OKS_RENEW_PVT.Debug_Log

2974: x_return_status => l_return_status,
2975: x_msg_count => l_msg_count,
2976: x_msg_data => l_msg_data);
2977:
2978: OKS_RENEW_PVT.Debug_Log
2979: (p_program_name => 'OKSCOPY'
2980: ,p_perf_msg =>'COPY_K_HDR_NOTES '||l_return_status);
2981:
2982: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3002: OKS_RENEW_PVT.Debug_Log

2998: x_return_status => l_return_status);
2999:
3000: x_return_status := l_return_status;
3001:
3002: OKS_RENEW_PVT.Debug_Log
3003: (p_program_name => 'OKSCOPY'
3004: ,p_perf_msg =>'copy Hedader salescredit Status '||l_return_status);
3005:
3006: END IF; --l_return_status = 'S'

Line 3020: OKS_RENEW_PVT.Debug_Log

3016: Copy_Hdr_Bill_Sch( p_chr_id => l_old_chr_id,
3017: p_new_chr_id => p_chr_id,
3018: x_return_status => l_return_status);
3019:
3020: OKS_RENEW_PVT.Debug_Log
3021: (p_program_name => 'OKSCOPY'
3022: ,p_perf_msg =>'copy Hedader Billing Schedule Status '||l_return_status);
3023: END IF;
3024: END IF;

Line 3080: OKS_RENEW_PVT.Debug_Log

3076: p_invoice_rule_id => l_inv_rule_id,
3077: x_bil_sch_out_tbl => l_bil_sch_out_tbl,
3078: x_return_status => l_return_status);
3079:
3080: OKS_RENEW_PVT.Debug_Log
3081: (p_program_name => 'OKSCOPY'
3082: ,p_perf_msg =>'copy Lines Billing Schedule Status '||l_return_status);
3083: END IF; --l_sll_count=0
3084: END IF; --l_duration_match = 'T'

Line 3101: OKS_RENEW_PVT.Debug_Log

3097: x_msg_count => l_msg_count ,
3098: x_msg_data => l_msg_data ,
3099: p_contract_line_id => check_top_line_exist_rec.id );
3100:
3101: OKS_RENEW_PVT.Debug_Log
3102: (p_program_name => 'OKSCOPY'
3103: ,p_perf_msg =>'Copy Coverage Status '||l_return_status);
3104:
3105: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3134: OKS_RENEW_PVT.Debug_Log

3130: x_return_status => l_return_status);
3131:
3132: END IF;
3133:
3134: OKS_RENEW_PVT.Debug_Log
3135: (p_program_name => 'OKSCOPY'
3136: ,p_perf_msg =>'copy Lines Attr Status '||l_return_status);
3137:
3138: --check item exists

Line 3177: OKS_RENEW_PVT.Debug_Log

3173: p_cle_id => check_top_line_exist_rec.id,
3174: x_return_status => l_return_status);
3175: x_return_status := l_return_status;
3176:
3177: OKS_RENEW_PVT.Debug_Log
3178: (p_program_name => 'OKSCOPY'
3179: ,p_perf_msg =>'check CCR Rule Status '||l_return_status);
3180:
3181: END IF; --l_return_status = 'S'

Line 3193: OKS_RENEW_PVT.Debug_Log

3189: p_new_chr_id => check_top_line_exist_rec.dnz_chr_id,
3190: x_return_status => l_return_status);
3191: x_return_status := l_return_status;
3192:
3193: OKS_RENEW_PVT.Debug_Log
3194: (p_program_name => 'OKSCOPY'
3195: ,p_perf_msg =>'Copy Lines revenue dist Status '||l_return_status);
3196: END IF; --l_return_status = 'S'
3197:

Line 3209: OKS_RENEW_PVT.Debug_Log

3205: x_return_status => l_return_status);
3206:
3207: x_return_status := l_return_status;
3208:
3209: OKS_RENEW_PVT.Debug_Log
3210: (p_program_name => 'OKSCOPY'
3211: ,p_perf_msg =>'Copy Line Sales Credit Status '||l_return_status);
3212:
3213: END IF; --l_return_status = 'S'

Line 3228: OKS_RENEW_PVT.Debug_Log

3224: x_msg_count => l_msg_count ,
3225: x_msg_data => l_msg_data ,
3226: p_contract_line_id => check_top_line_exist_rec.id );
3227:
3228: OKS_RENEW_PVT.Debug_Log
3229: (p_program_name => 'OKSCOPY'
3230: ,p_perf_msg =>'Copy Coverage Status '||l_return_status);
3231:
3232: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3246: OKS_RENEW_PVT.Debug_Log

3242: ,check_top_line_exist_rec.id
3243: ,null
3244: ,l_return_status);
3245:
3246: OKS_RENEW_PVT.Debug_Log
3247: (p_program_name => 'OKSCOPY'
3248: ,p_perf_msg =>'Copy subscr_inst Status '||l_return_status);
3249:
3250: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3289: OKS_RENEW_PVT.Debug_Log

3285: p_new_cle_id => cle_grp_rec.id,
3286: p_new_chr_id => cle_grp_rec.dnz_chr_id,
3287: x_return_status => l_return_status);
3288:
3289: OKS_RENEW_PVT.Debug_Log
3290: (p_program_name => 'OKSCOPY'
3291: ,p_perf_msg =>'Line Copy line_attr Status'||l_return_status);
3292:
3293: END IF;

Line 3316: OKS_RENEW_PVT.Debug_Log

3312: p_new_chr_id => cle_grp_rec.dnz_chr_id,
3313: x_return_status => l_return_status);
3314:
3315: x_return_status := l_return_status;
3316: OKS_RENEW_PVT.Debug_Log
3317: (p_program_name => 'OKSCOPY'
3318: ,p_perf_msg =>'Line Copy line_revenue_dist Status'||l_return_status);
3319: END IF; --l_return_status = 'S'
3320:

Line 3332: OKS_RENEW_PVT.Debug_Log

3328: x_return_status => l_return_status);
3329:
3330: x_return_status := l_return_status;
3331:
3332: OKS_RENEW_PVT.Debug_Log
3333: (p_program_name => 'OKSCOPY'
3334: ,p_perf_msg =>'Line Copy line_sales_credit Status'||l_return_status);
3335:
3336: END IF; --l_return_status = 'S'

Line 3344: OKS_RENEW_PVT.Debug_Log

3340: p_cle_id => cle_grp_rec.id,
3341: x_return_status => l_return_status);
3342: x_return_status := l_return_status;
3343:
3344: OKS_RENEW_PVT.Debug_Log
3345: (p_program_name => 'OKSCOPY'
3346: ,p_perf_msg =>'check CCR Rule Status'||l_return_status);
3347:
3348: END IF; --l_return_status = 'S'

Line 3356: OKS_RENEW_PVT.Debug_Log

3352: ,cle_grp_rec.id
3353: ,null
3354: ,l_return_status);
3355:
3356: OKS_RENEW_PVT.Debug_Log
3357: (p_program_name => 'OKSCOPY'
3358: ,p_perf_msg =>'Line Copy line_subscr_inst Status'||l_return_status);
3359: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
3360: x_return_status := l_return_status;

Line 3377: OKS_RENEW_PVT.Debug_Log

3373: x_msg_count => l_msg_count ,
3374: x_msg_data => l_msg_data ,
3375: p_contract_line_id => cle_grp_rec.id );
3376:
3377: OKS_RENEW_PVT.Debug_Log
3378: (p_program_name => 'OKSCOPY'
3379: ,p_perf_msg =>'Copy Coverage Status'||l_return_status);
3380:
3381: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 3455: OKS_RENEW_PVT.Debug_Log

3451: update_line_numbers (p_chr_id => p_chr_id
3452: ,p_update_top_line => l_update_top_line
3453: ,x_return_status => l_return_status);
3454:
3455: OKS_RENEW_PVT.Debug_Log
3456: (p_program_name => 'OKSCOPY'
3457: ,p_perf_msg =>'Update Line Number Status'||l_return_status);
3458:
3459: x_return_status := l_return_status;

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

3472: Close get_price_list;
3473: -- For renewal the price lock doesnt get copied in the first
3474: -- okscopy call. It gets copied in the second call only
3475: -- if the price list ids are the same.
3476: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3477: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3478: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3479: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3480: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',

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

3474: -- okscopy call. It gets copied in the second call only
3475: -- if the price list ids are the same.
3476: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3477: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3478: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3479: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3480: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3481: p_perf_msg =>'new contract lse id: ' || get_lines_rec.lse_id);
3482: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then

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

3476: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3477: p_perf_msg =>'old price list id: ' || l_old_price_list_id);
3478: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3479: p_perf_msg =>'new price list id: ' || get_lines_rec.price_list_id);
3480: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3481: p_perf_msg =>'new contract lse id: ' || get_lines_rec.lse_id);
3482: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then
3483: Open get_contract_number(p_chr_id);
3484: Fetch get_contract_number into l_contract_number;

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

3482: If nvl(l_old_price_list_id, -99) = nvl(get_lines_rec.price_list_id, -99) Then
3483: Open get_contract_number(p_chr_id);
3484: Fetch get_contract_number into l_contract_number;
3485: Close get_contract_number;
3486: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3487: p_perf_msg =>'Calling QP API');
3488: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3489: p_perf_msg =>' get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID: ' || get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID);
3490: -- MKS Commented out.. Need to put back in once QP patch is ready.

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

3484: Fetch get_contract_number into l_contract_number;
3485: Close get_contract_number;
3486: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3487: p_perf_msg =>'Calling QP API');
3488: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3489: p_perf_msg =>' get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID: ' || get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID);
3490: -- MKS Commented out.. Need to put back in once QP patch is ready.
3491: /*
3492: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => get_oks_line_attr.LOCKED_PRICE_LIST_LINE_ID,

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

3498: x_msg_count => l_msg_count,
3499: x_msg_data => l_msg_data);
3500:
3501: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
3502: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3503: p_perf_msg =>'QP failed.');
3504: RAISE G_EXCEPTION_HALT_VALIDATION;
3505: END IF;
3506: */

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

3507: select id
3508: into l_oks_line_id
3509: from oks_k_lines_b where cle_id = get_lines_rec.id;
3510:
3511: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3512: p_perf_msg =>'After cursor call');
3513: Update oks_k_lines_b set
3514: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3515: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,

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

3514: LOCKED_PRICE_LIST_ID = l_locked_price_list_id,
3515: LOCKED_PRICE_LIST_LINE_ID = l_locked_price_list_line_id,
3516: break_uom = get_oks_line_attr.break_uom
3517: where id = l_oks_line_id;
3518: OKS_RENEW_PVT.Debug_Log(p_program_name => 'OKSCOPY',
3519: p_perf_msg =>'After update');
3520:
3521: End If; -- if price list ids are different
3522: End If; -- if original contract has a price list id

Line 3528: OKS_RENEW_PVT.Debug_Log

3524: End Loop; -- loop through new contracts
3525: End If; -- if being called in renew the second time
3526:
3527:
3528: OKS_RENEW_PVT.Debug_Log
3529: (p_program_name => 'OKSCOPY'
3530: ,p_perf_msg =>'OKSCOPY: end time= '||to_char(sysdate,'HH:MI:SS'));
3531:
3532: x_return_status := l_return_status;