259: IF(l_debug_level>1) THEN
260: FND_File.Put_Line(Fnd_File.LOG,'In WHEN OTHERS Exception in:'||l_api_name);
261: END IF;
262: l_sql_error := SQLERRM;
263: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
264: fnd_message.set_token('API_NAME',l_api_name);
265: fnd_message.set_token('SQL_ERROR',SQLERRM);
266: x_msg_data := fnd_message.get;
267: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
260: FND_File.Put_Line(Fnd_File.LOG,'In WHEN OTHERS Exception in:'||l_api_name);
261: END IF;
262: l_sql_error := SQLERRM;
263: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
264: fnd_message.set_token('API_NAME',l_api_name);
265: fnd_message.set_token('SQL_ERROR',SQLERRM);
266: x_msg_data := fnd_message.get;
267: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
268: x_return_status := l_fnd_unexpected;
261: END IF;
262: l_sql_error := SQLERRM;
263: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
264: fnd_message.set_token('API_NAME',l_api_name);
265: fnd_message.set_token('SQL_ERROR',SQLERRM);
266: x_msg_data := fnd_message.get;
267: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
268: x_return_status := l_fnd_unexpected;
269:
262: l_sql_error := SQLERRM;
263: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
264: fnd_message.set_token('API_NAME',l_api_name);
265: fnd_message.set_token('SQL_ERROR',SQLERRM);
266: x_msg_data := fnd_message.get;
267: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
268: x_return_status := l_fnd_unexpected;
269:
270: END create_instances;
644: END LOOP;
645: COMMIT;
646:
647: l_sql_error := SQLERRM;
648: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
649: fnd_message.set_token('API_NAME',l_api_name);
650: fnd_message.set_token('SQL_ERROR',SQLERRM);
651: x_msg_data := fnd_message.get;
652: FND_File.Put_Line(Fnd_File.LOG,substr(x_msg_data,1,200));
645: COMMIT;
646:
647: l_sql_error := SQLERRM;
648: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
649: fnd_message.set_token('API_NAME',l_api_name);
650: fnd_message.set_token('SQL_ERROR',SQLERRM);
651: x_msg_data := fnd_message.get;
652: FND_File.Put_Line(Fnd_File.LOG,substr(x_msg_data,1,200));
653: x_return_status := l_fnd_unexpected;
646:
647: l_sql_error := SQLERRM;
648: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
649: fnd_message.set_token('API_NAME',l_api_name);
650: fnd_message.set_token('SQL_ERROR',SQLERRM);
651: x_msg_data := fnd_message.get;
652: FND_File.Put_Line(Fnd_File.LOG,substr(x_msg_data,1,200));
653: x_return_status := l_fnd_unexpected;
654:
647: l_sql_error := SQLERRM;
648: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
649: fnd_message.set_token('API_NAME',l_api_name);
650: fnd_message.set_token('SQL_ERROR',SQLERRM);
651: x_msg_data := fnd_message.get;
652: FND_File.Put_Line(Fnd_File.LOG,substr(x_msg_data,1,200));
653: x_return_status := l_fnd_unexpected;
654:
655: END create_parallel_instances;
710: IF(l_debug_level>1) THEN
711: FND_File.Put_Line(Fnd_File.LOG,'In WHEN OTHERS Exception in:'||l_api_name);
712: END IF;
713: l_sql_error := SQLERRM;
714: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
715: fnd_message.set_token('API_NAME',l_api_name);
716: fnd_message.set_token('SQL_ERROR',SQLERRM);
717: x_msg_data := fnd_message.get;
718: IF(l_debug_level>1) THEN
711: FND_File.Put_Line(Fnd_File.LOG,'In WHEN OTHERS Exception in:'||l_api_name);
712: END IF;
713: l_sql_error := SQLERRM;
714: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
715: fnd_message.set_token('API_NAME',l_api_name);
716: fnd_message.set_token('SQL_ERROR',SQLERRM);
717: x_msg_data := fnd_message.get;
718: IF(l_debug_level>1) THEN
719: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
712: END IF;
713: l_sql_error := SQLERRM;
714: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
715: fnd_message.set_token('API_NAME',l_api_name);
716: fnd_message.set_token('SQL_ERROR',SQLERRM);
717: x_msg_data := fnd_message.get;
718: IF(l_debug_level>1) THEN
719: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
720: END IF;
713: l_sql_error := SQLERRM;
714: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
715: fnd_message.set_token('API_NAME',l_api_name);
716: fnd_message.set_token('SQL_ERROR',SQLERRM);
717: x_msg_data := fnd_message.get;
718: IF(l_debug_level>1) THEN
719: FND_File.Put_Line(Fnd_File.LOG,x_msg_data);
720: END IF;
721: x_return_status := l_fnd_unexpected;