DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on FND_FILE

Line 437: FND_FILE.PUT_LINE (FND_FILE.LOG, 'OKS_EXTWAR_UTIL_PVT.get_k_order_details : LINK CHR ID - '

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:

Line 5451: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;

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;

Line 5452: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;

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') ;

Line 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') ;

Line 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') ;

Line 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') ;

Line 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