DBA Data[Home] [Help]

APPS.OKL_CURE_CALC_PVT dependencies on FND_FILE

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

1087:
1088: PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2) is
1089: BEGIN
1090: if (mesg_level >= l_msgLevel) then
1091: fnd_file.put_line(FND_FILE.LOG, mesg);
1092: end if;
1093:
1094:
1095: END;

Line 1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');

1097: Procedure print_log
1098: (p_contract_number VARCHAR2) IS
1099: BEGIN
1100:
1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');
1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);

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

1098: (p_contract_number VARCHAR2) IS
1099: BEGIN
1100:
1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');
1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');

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

1099: BEGIN
1100:
1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');
1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1107:

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

1100:
1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');
1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1107:
1108: IF l_success_tbl.COUNT > 0 THEN

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

1101: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Generate Cure Amounts');
1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1107:
1108: IF l_success_tbl.COUNT > 0 THEN
1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||

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

1102: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Program Run Date:'||SYSDATE);
1103: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'PARAMETERS');
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1107:
1108: IF l_success_tbl.COUNT > 0 THEN
1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||
1110: l_success_tbl.COUNT || ' Contracts ');

Line 1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||

1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Contract Number = ' ||p_contract_number);
1106: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1107:
1108: IF l_success_tbl.COUNT > 0 THEN
1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||
1110: l_success_tbl.COUNT || ' Contracts ');
1111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1112: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST LOOP
1113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||

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

1107:
1108: IF l_success_tbl.COUNT > 0 THEN
1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||
1110: l_success_tbl.COUNT || ' Contracts ');
1111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1112: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST LOOP
1113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||
1114: l_success_tbl(i).contract_number || ' Cure Type is '||
1115: l_success_tbl(i).cure_type || ' Cure Amount '||

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

1109: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Generated for '||
1110: l_success_tbl.COUNT || ' Contracts ');
1111: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1112: FOR i in l_success_tbl.FIRST..l_success_tbl.LAST LOOP
1113: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,'Contract Number ' ||
1114: l_success_tbl(i).contract_number || ' Cure Type is '||
1115: l_success_tbl(i).cure_type || ' Cure Amount '||
1116: l_success_tbl(i).cure_amount );
1117: END LOOP;

Line 1121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Not Generated For '||

1117: END LOOP;
1118: END IF;
1119:
1120: IF l_error_tbl.COUNT > 0 THEN
1121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Not Generated For '||
1122: l_error_tbl.COUNT || ' Contracts ');
1123: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1124: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
1125: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,' Contract Number ' ||

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

1119:
1120: IF l_error_tbl.COUNT > 0 THEN
1121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Not Generated For '||
1122: l_error_tbl.COUNT || ' Contracts ');
1123: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1124: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
1125: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,' Contract Number ' ||
1126: l_error_tbl(i).contract_number );
1127:

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

1121: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Cure Amounts Not Generated For '||
1122: l_error_tbl.COUNT || ' Contracts ');
1123: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '***********************************************');
1124: FOR i in l_error_tbl.FIRST..l_error_tbl.LAST LOOP
1125: FND_FILE.PUT_LINE (FND_FILE.OUTPUT ,' Contract Number ' ||
1126: l_error_tbl(i).contract_number );
1127:
1128: END LOOP;
1129: END IF;

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

1799: okl_debug_pub.logmessage('GENERATE_CURE_AMOUNT: END');
1800:
1801: EXCEPTION
1802: WHEN OTHERS THEN
1803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (OTHERS)IN OKL_CURE_CALC_PVT => '||SQLERRM);
1804: retcode :=2;
1805: errbuf :=SQLERRM;
1806:
1807: END GENERATE_CURE_AMOUNT;