433: FETCH c_Chr INTO l_link_chr_id;
434: CLOSE c_Chr;
435:
436: IF l_link_chr_id IS NULL THEN
437: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKS_EXTWAR_UTIL_PVT.get_k_order_details : LINK CHR ID - '
438: ||TO_CHAR(l_Renewal_Rec.Link_Chr_Id)
439: ||'is TERMINATED or CANCELLED');
440: END IF;
441:
5447: WHERE conc_request_id = p_conc_request_id;
5448:
5449: COMMIT;
5450:
5451: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;
5452: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5453: IF p_orgid IS NULL AND p_curr IS NULL
5454: THEN
5455: OPEN l_kh_csr4;
5448:
5449: COMMIT;
5450:
5451: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;
5452: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5453: IF p_orgid IS NULL AND p_curr IS NULL
5454: THEN
5455: OPEN l_kh_csr4;
5456: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;
5452: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5453: IF p_orgid IS NULL AND p_curr IS NULL
5454: THEN
5455: OPEN l_kh_csr4;
5456: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;
5457: ELSIF p_orgid IS NULL AND p_curr IS NOT NULL
5458: THEN
5459: OPEN l_kh_csr2;
5460: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;
5456: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;
5457: ELSIF p_orgid IS NULL AND p_curr IS NOT NULL
5458: THEN
5459: OPEN l_kh_csr2;
5460: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;
5461: ELSIF p_orgid IS NOT NULL AND p_curr IS NULL
5462: THEN
5463: OPEN l_kh_csr3;
5464: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;
5460: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;
5461: ELSIF p_orgid IS NOT NULL AND p_curr IS NULL
5462: THEN
5463: OPEN l_kh_csr3;
5464: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;
5465: ELSIF p_orgid IS NOT NULL AND p_curr IS NOT NULL
5466: THEN
5467: OPEN l_kh_csr1;
5468: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr1') ;
5464: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;
5465: ELSIF p_orgid IS NOT NULL AND p_curr IS NOT NULL
5466: THEN
5467: OPEN l_kh_csr1;
5468: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr1') ;
5469: END IF;
5470:
5471: -- For l_kh_rec in l_kh_csr
5472: LOOP