DBA Data[Home] [Help]

APPS.OKL_VENDOR_REFUND_PVT dependencies on FND_FILE

Line 338: fnd_file.put_line(FND_FILE.LOG, mesg);

334: IS
335: BEGIN
336: IF (mesg_level >= l_msgLevel)
337: THEN
338: fnd_file.put_line(FND_FILE.LOG, mesg);
339: END IF;
340: END;
341:
342: PROCEDURE print_log (p_contract_number VARCHAR2)

Line 345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');

341:
342: PROCEDURE print_log (p_contract_number VARCHAR2)
343: IS
344: BEGIN
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);

Line 346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);

342: PROCEDURE print_log (p_contract_number VARCHAR2)
343: IS
344: BEGIN
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

Line 347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

343: IS
344: BEGIN
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
351:

Line 348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');

344: BEGIN
345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
351:
352: IF l_success_tbl.COUNT > 0

Line 349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);

345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Refund');
346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
351:
352: IF l_success_tbl.COUNT > 0
353: THEN

Line 350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
347: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
348: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
349: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
351:
352: IF l_success_tbl.COUNT > 0
353: THEN
354: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

Line 354: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
351:
352: IF l_success_tbl.COUNT > 0
353: THEN
354: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
355: 'Cure Refund Generated for '||l_success_tbl.COUNT || ' Contracts ');
356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
357: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST
358: LOOP

Line 356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

352: IF l_success_tbl.COUNT > 0
353: THEN
354: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
355: 'Cure Refund Generated for '||l_success_tbl.COUNT || ' Contracts ');
356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
357: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST
358: LOOP
359: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||
360: l_success_tbl(i).contract_number || ' Cure Type is '||

Line 359: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||

355: 'Cure Refund Generated for '||l_success_tbl.COUNT || ' Contracts ');
356: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
357: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST
358: LOOP
359: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||
360: l_success_tbl(i).contract_number || ' Cure Type is '||
361: l_success_tbl(i).cure_type || ' Cure Amount '||
362: l_success_tbl(i).cure_amount );
363: END LOOP;

Line 368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

364: END IF;
365:
366: IF l_error_tbl.COUNT > 0
367: THEN
368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
369: 'Cure Refund Not Generated For '||l_error_tbl.COUNT || ' Contracts ');
370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
371: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST
372: LOOP

Line 370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

366: IF l_error_tbl.COUNT > 0
367: THEN
368: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
369: 'Cure Refund Not Generated For '||l_error_tbl.COUNT || ' Contracts ');
370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
371: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST
372: LOOP
373: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,
374: ' Contract Number '||l_error_tbl(i).contract_number );

Line 373: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,

369: 'Cure Refund Not Generated For '||l_error_tbl.COUNT || ' Contracts ');
370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
371: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST
372: LOOP
373: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,
374: ' Contract Number '||l_error_tbl(i).contract_number );
375: END LOOP;
376: END IF;
377: END print_log;

Line 832: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN OKL_CURE_CALC_PVT => '||SQLERRM);

828: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : END ');
829:
830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN OKL_CURE_CALC_PVT => '||SQLERRM);
833: retcode :=2;
834: errbuf :=SQLERRM;
835:
836: END GENERATE_VENDOR_REFUND;