676: x_error_count => l_error_count);
677:
678:
679: -- Add couple of blank lines
680: fnd_file.new_line(fnd_file.log,2);
681: fnd_file.new_line(fnd_file.output,2);
682:
683: -- Get the messages in the log
684: LOOP
677:
678:
679: -- Add couple of blank lines
680: fnd_file.new_line(fnd_file.log,2);
681: fnd_file.new_line(fnd_file.output,2);
682:
683: -- Get the messages in the log
684: LOOP
685:
690: p_msg_index_out => lx_error_rec.msg_count);
691:
692: IF (lx_error_rec.msg_count IS NOT NULL) THEN
693:
694: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
695: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
696:
697: END IF;
698:
691:
692: IF (lx_error_rec.msg_count IS NOT NULL) THEN
693:
694: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
695: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
696:
697: END IF;
698:
699: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
702: l_msg_idx := FND_MSG_PUB.G_NEXT;
703: END LOOP;
704:
705:
706: fnd_file.new_line(fnd_file.log,2);
707: fnd_file.new_line(fnd_file.output,2);
708:
709: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
710: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
703: END LOOP;
704:
705:
706: fnd_file.new_line(fnd_file.log,2);
707: fnd_file.new_line(fnd_file.output,2);
708:
709: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
710: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
711: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
706: fnd_file.new_line(fnd_file.log,2);
707: fnd_file.new_line(fnd_file.output,2);
708:
709: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
710: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
711: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
712: END IF;
713:
714: IF l_total_count = 0 THEN
707: fnd_file.new_line(fnd_file.output,2);
708:
709: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
710: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
711: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
712: END IF;
713:
714: IF l_total_count = 0 THEN
715: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
711: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Update Failed, None of the transactions got processed.');
712: END IF;
713:
714: IF l_total_count = 0 THEN
715: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
716: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
717: ELSE
718:
719: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
712: END IF;
713:
714: IF l_total_count = 0 THEN
715: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
716: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
717: ELSE
718:
719: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
720: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
715: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
716: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
717: ELSE
718:
719: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
720: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
721: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
722:
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
716: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
717: ELSE
718:
719: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
720: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
721: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
722:
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
724:
717: ELSE
718:
719: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
720: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
721: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
722:
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
724:
725: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
721: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
722:
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
724:
725: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
726: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
727: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
728:
729: IF l_unchanged_txn_count > 0 THEN
722:
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
724:
725: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
726: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
727: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
728:
729: IF l_unchanged_txn_count > 0 THEN
730: fnd_file.new_line(fnd_file.log,1);
723: l_unchanged_txn_count := (l_total_count - (l_processed_count + l_error_count )) ;
724:
725: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
726: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
727: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
728:
729: IF l_unchanged_txn_count > 0 THEN
730: fnd_file.new_line(fnd_file.log,1);
731: fnd_file.new_line(fnd_file.output,1);
726: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
727: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
728:
729: IF l_unchanged_txn_count > 0 THEN
730: fnd_file.new_line(fnd_file.log,1);
731: fnd_file.new_line(fnd_file.output,1);
732:
733: fnd_file.put_line(fnd_file.log, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
734: fnd_file.put_line(fnd_file.output, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
727: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
728:
729: IF l_unchanged_txn_count > 0 THEN
730: fnd_file.new_line(fnd_file.log,1);
731: fnd_file.new_line(fnd_file.output,1);
732:
733: fnd_file.put_line(fnd_file.log, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
734: fnd_file.put_line(fnd_file.output, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
735: END IF;
729: IF l_unchanged_txn_count > 0 THEN
730: fnd_file.new_line(fnd_file.log,1);
731: fnd_file.new_line(fnd_file.output,1);
732:
733: fnd_file.put_line(fnd_file.log, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
734: fnd_file.put_line(fnd_file.output, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
735: END IF;
736:
737: END IF;
730: fnd_file.new_line(fnd_file.log,1);
731: fnd_file.new_line(fnd_file.output,1);
732:
733: fnd_file.put_line(fnd_file.log, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
734: fnd_file.put_line(fnd_file.output, l_unchanged_txn_count||' transactions were not processed as there is no change in the budget amount.');
735: END IF;
736:
737: END IF;
738:
1092: x_error_count => l_error_count);
1093:
1094:
1095: -- Add couple of blank lines
1096: fnd_file.new_line(fnd_file.log,2);
1097: fnd_file.new_line(fnd_file.output,2);
1098:
1099: -- Get the messages in the log
1100: LOOP
1093:
1094:
1095: -- Add couple of blank lines
1096: fnd_file.new_line(fnd_file.log,2);
1097: fnd_file.new_line(fnd_file.output,2);
1098:
1099: -- Get the messages in the log
1100: LOOP
1101:
1106: p_msg_index_out => lx_error_rec.msg_count);
1107:
1108: IF (lx_error_rec.msg_count IS NOT NULL) THEN
1109:
1110: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
1111: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
1112:
1113: END IF;
1114:
1107:
1108: IF (lx_error_rec.msg_count IS NOT NULL) THEN
1109:
1110: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
1111: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
1112:
1113: END IF;
1114:
1115: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG)
1118: l_msg_idx := FND_MSG_PUB.G_NEXT;
1119: END LOOP;
1120:
1121:
1122: fnd_file.new_line(fnd_file.log,2);
1123: fnd_file.new_line(fnd_file.output,2);
1124:
1125: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1126: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1119: END LOOP;
1120:
1121:
1122: fnd_file.new_line(fnd_file.log,2);
1123: fnd_file.new_line(fnd_file.output,2);
1124:
1125: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1126: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1127: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1122: fnd_file.new_line(fnd_file.log,2);
1123: fnd_file.new_line(fnd_file.output,2);
1124:
1125: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1126: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1127: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1128: END IF;
1129:
1130: IF l_total_count = 0 THEN
1123: fnd_file.new_line(fnd_file.output,2);
1124:
1125: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1126: fnd_file.put_line(fnd_file.log, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1127: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1128: END IF;
1129:
1130: IF l_total_count = 0 THEN
1131: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
1127: fnd_file.put_line(fnd_file.output, 'Portfolio Management Strategy Profile Execution Failed, None of the transactions got processed.');
1128: END IF;
1129:
1130: IF l_total_count = 0 THEN
1131: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
1132: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
1133: ELSE
1134:
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1128: END IF;
1129:
1130: IF l_total_count = 0 THEN
1131: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
1132: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
1133: ELSE
1134:
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1131: fnd_file.put_line(fnd_file.log, 'There were no portfolio management strategy profile transactions to process.');
1132: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
1133: ELSE
1134:
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1132: fnd_file.put_line(fnd_file.output,'There were no portfolio management strategy profile transactions to process.');
1133: ELSE
1134:
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1140: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
1133: ELSE
1134:
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1140: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
1141: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
1135: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1140: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
1141: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
1142:
1143: END IF;
1136: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1140: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
1141: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
1142:
1143: END IF;
1144:
1137: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
1138:
1139: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
1140: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
1141: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
1142:
1143: END IF;
1144:
1145: