APPS.OKS_ARFETCH_PUB dependencies on FND_FILE

Line 42: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(user_id));

38: BEGIN
39:
40:
41: user_id := FND_GLOBAL.USER_ID;
42: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User_Id ='||to_char(user_id));
43:
44: OKS_ARFETCH_PUB.GET_AR_RECORD(l_return_status);
45: --OKS_ARFETCH_PUB.GET_AR_RECORD(l_retcode);
46:

Line 50: FND_FILE.PUT_LINE( FND_FILE.LOG,

46:
47: --l_retcode := SUCCESS;
48:
49: IF (l_return_status = 'S') THEN
50: FND_FILE.PUT_LINE( FND_FILE.LOG,
51: 'ARFetch_Main IS successfully completed');
52: ELSE
53: FND_FILE.PUT_LINE( FND_FILE.LOG,
54: 'ARFetch_Main is NOT successfully completed' );

Line 53: FND_FILE.PUT_LINE( FND_FILE.LOG,

49: IF (l_return_status = 'S') THEN
50: FND_FILE.PUT_LINE( FND_FILE.LOG,
51: 'ARFetch_Main IS successfully completed');
52: ELSE
53: FND_FILE.PUT_LINE( FND_FILE.LOG,
54: 'ARFetch_Main is NOT successfully completed' );
55: END IF;
56:
57:

Line 58: --FND_FILE.PUT_LINE (FND_FILE.LOG,'RETCODE = ' || to_char(l_retcode));

54: 'ARFetch_Main is NOT successfully completed' );
55: END IF;
56:
57:
58: --FND_FILE.PUT_LINE (FND_FILE.LOG,'RETCODE = ' || to_char(l_retcode));
59:
60: COMMIT;
61:
62: IF (conc_ret_code = SUCCESS) THEN

Line 266: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TRANSACTIONS , SQLERRM = '|| SQLERRM);

262: ,last_update_date = sysdate
263: where id = l_txn_id(i);
264: Exception
265: When others then
266: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TRANSACTIONS , SQLERRM = '|| SQLERRM);
267: Raise;
268: End;
269:
270: BEGIN

Line 397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TXN_LINES , SQLERRM = '|| SQLERRM);

393:
394:
395: EXCEPTION
396: WHEN OTHERS THEN
397: FND_FILE.PUT_LINE(FND_FILE.LOG,'Update failed on OKS_BILL_TXN_LINES , SQLERRM = '|| SQLERRM);
398: Raise;
399: END;
400:
401: Begin

Line 408: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert failed on OKS_AR_FETCH_TEMP , SQLERRM = '|| SQLERRM);

404: ( hdr_id )
405: values ( l_hdr_id(k));
406: Exception
407: When others then
408: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert failed on OKS_AR_FETCH_TEMP , SQLERRM = '|| SQLERRM);
409: Raise;
410: End ;
411: End If;
412: Exit when get_fetch_records_csr%NOTFOUND;

Line 442: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error'||SQLCODE || '- '||SQLERRM);

438: EXCEPTION
439: WHEN OTHERS THEN
440: x_return_status := 'E';
441: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error'||SQLCODE || '- '||SQLERRM);
443: END Get_AR_RECORD;
444:
445: END OKS_ARFETCH_PUB;