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 5405: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;

5401: WHERE conc_request_id = p_conc_request_id;
5402:
5403: COMMIT;
5404:
5405: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;
5406: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5407: IF p_orgid IS NULL AND p_curr IS NULL
5408: THEN
5409: OPEN l_kh_csr4;

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

5402:
5403: COMMIT;
5404:
5405: -- fnd_file.put_line(FND_FILE.LOG, 'P_Orgid: '||P_Orgid) ;
5406: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5407: IF p_orgid IS NULL AND p_curr IS NULL
5408: THEN
5409: OPEN l_kh_csr4;
5410: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;

Line 5410: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;

5406: -- fnd_file.put_line(FND_FILE.LOG, 'P_Curr: '||P_Curr) ;
5407: IF p_orgid IS NULL AND p_curr IS NULL
5408: THEN
5409: OPEN l_kh_csr4;
5410: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;
5411: ELSIF p_orgid IS NULL AND p_curr IS NOT NULL
5412: THEN
5413: OPEN l_kh_csr2;
5414: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;

Line 5414: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;

5410: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr4') ;
5411: ELSIF p_orgid IS NULL AND p_curr IS NOT NULL
5412: THEN
5413: OPEN l_kh_csr2;
5414: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;
5415: ELSIF p_orgid IS NOT NULL AND p_curr IS NULL
5416: THEN
5417: OPEN l_kh_csr3;
5418: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;

Line 5418: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;

5414: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr2') ;
5415: ELSIF p_orgid IS NOT NULL AND p_curr IS NULL
5416: THEN
5417: OPEN l_kh_csr3;
5418: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;
5419: ELSIF p_orgid IS NOT NULL AND p_curr IS NOT NULL
5420: THEN
5421: OPEN l_kh_csr1;
5422: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr1') ;

Line 5422: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr1') ;

5418: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr3') ;
5419: ELSIF p_orgid IS NOT NULL AND p_curr IS NOT NULL
5420: THEN
5421: OPEN l_kh_csr1;
5422: -- fnd_file.put_line(FND_FILE.LOG, 'l_kh_csr1') ;
5423: END IF;
5424:
5425: -- For l_kh_rec in l_kh_csr
5426: LOOP